A data source node allows you to select any table or view in the current account (schema). In addition to tables in the current account, you can select
tables in other accounts that you have permission to use. This cue card set uses data in the Sales History (SH
) schema, one of Oracle Database Sample Schemas.
This cue card set requires that the SH
schema is installed.
Follow these steps to use data in the SH
:
Create a new workflow: In the Data Miner Navigator: expand dmConnection
; right-click
HighValue
; select New Workflow. Name the workflow StarSchemaMining
.
If the Component Palette is not open, open it using View > Component Palette.
Make sure that Workflow Editor is selected.
Add the SH schema as a data source, and then create a data source node for the table SH.CUSTOMERS:
SH
from the list of Available Schemas to the list of Selected Schemas.
Click OK.SH
.SH.CUSTOMERS
; click Finish to include all of the columns.Create a second data source node:
SH
.SH.SALES
; click Finish.
Tell me more about what I see in the GUI
The
Next step is to prepare data using an aggregation node.
Copyright © 2011, 2012, Oracle. All rights reserved.