The data menu provides a collection of wizards that perform common data preparation steps. SQL Worksheet on the Tools menu may also be useful during data preparation.
The Data menu contains the commands Copy Table, Create Table (from a view), Create View (a visual query builder), Generate SQL, Import From File, Show Lineage, Show Summary, and the Transform submenu.
The Transform submenu contains the following transformations: Aggregate, Discretize (bin), Variation Filter, Filter Single-Record case table, Compute Field (create a new column by applying SQL functions to existing columns), Missing Value (detect and treat missing values), Numeric (modify data distribution characteristics and/or normalize data), Outlier Treatment (identify and treat extreme values), Sample, Stratified Sample, and Split.
Copyright © 2005, Oracle. All rights reserved.