Databases Reference
In-Depth Information
Name
Description
Summary
Statistics -
Report
creates an HTML report that contains summary statistics.
Summary
Tables -
Report
creates an HTML report that contains summary tables.
Control Folder
The following table describes the transformations in the Control folder in the Process
Library.
Table A1.3
Control Folder Transformations
Name
Description
Loop
marks the beginning of the iterative processing sequence in an iterative job.
Loop End
marks the end of the iterative processing sequence in an iterative job.
Return Code
Check
provides status-handling logic at a desired point in the process flow diagram for a
job. Can be inserted between existing transformations and removed later without
affecting the mappings in the original process flow.
Data Transforms Folder
The following table describes the transformations in the Data Transforms folder in
the Process Library.
Table A1.4
Data Transforms Folder Transformations
Name
Description
Append
creates a single target table by combining data from several source tables.
Apply
Lookup
Standardization
applies scheme data sets to transform source columns.
Create
Match Code
establishes relationships between source rows using match code analysis or cluster
analysis.
Data
Transfer
moves data directly from one machine to another. Direct data transfer is more
efficient than the default transfer mechanism.
Data
Validation
cleanses data before it is added to a data warehouse or data mart.
Extract
selects multiple sets of rows from a source and writes those rows to a target.
Typically used to create one subset from a source. Can also be used to create
columns in a target that are derived from columns in a source.
Fact Table
Lookup
loads source data into a fact table and translates business keys into generated keys.
Search WWH ::
Custom Search