This cue card set uses the connection and project created in Getting Started with Data Miner.
Follow these steps to create a new workflow named Transformations
:
dmConnection
.HighValue
; select New Workflow.Transformations
.If the Component Palette is not open, open it using View > Component Palette. Make sure that Workflow Editor is selected.
Create a data source node for the data to explore:
MINING_DATA_BUILD_V
. The columns (attributes) of the view are displayed.MINING_DATA_BUILD_V
, the name of the table.Explore the data in MINING_DATA_BUILD_V
before you transform it. Create and run an Explore Data node:
ExploreMiningData
by selecting the name and typing in the new name.MINING_DATA_BUILD_V
, and select Connect.
Use the mouse to draw the link to ExploreMiningData
. Click to end the line.ExploreMiningData
and select Run.After execution finishes, right-click ExploreMiningData
and select View Data. The data
viewer opens in a new tab ExploreMiningData.
Tell me more about what I see in the GUI.
Select an attribute such as CUST_INCOME_LEVEL
. CUST_INCOME_LEVEL
has data type VARCHAR2. The upper part of the display
shows the histogram, the data type, percent NULLs, the number of distinct values, the percent distinct values, and the mode.
A large version of the histogram is displayed in the bottom of the page.
When you are done exploring attributes, close the tab.
You are now ready to define transformations.
Tell me more about what I see in the GUI
The
Next step is identify important attributes.
Copyright © 2011, 2012, Oracle. All rights reserved.