Standard Transformations in the Process Library - SAS Data Integration Studio 3.3 User's Guide - page 220

Name Description

Key
Effective
Date

enables change tracking in intersection tables.

Lookup loads a target with columns taken from a source and from several lookup tables.

Mining
Results

integrates a SAS Enterprise Miner model into a SAS Data Integration Studio data
warehouse. Typically used to create target tables from a SAS Enterprise Miner
model.

SAS Rank ranks one or more numeric column variables in the source and stores the ranks in

the target.

SAS Sort reads data from a source, sorts it, and writes the sorted data to a target.

SAS Splitter selects multiple sets of rows from one source and writes each set of rows to a

different target. Typically used to create two or more subsets of a source. Can also
be used to create two or more copies of a source.

SCD Type 2
Loader

loads source data into a dimension table, detects changes between source and target
rows, updates change tracking columns, and applies generated key values. This
transformation implements slowly changing dimensions.

SQL Join selects multiple sets of rows from one or more sources and writes each set of rows to

a single target. Typically used to merge two or more sources into one target. Can
also be used to merge two or more copies of a single source.

Standardize creates an output table that contains data standardized to a particular number.

Surrogate
Key
Generator

loads a target, adds generated whole number values to a surrogate key column and
sorts and saves the source based on the values in the business key column(s).

Transpose creates an output table that contains transposed data.

User
Written
Code

retrieves a user-written transformation. Can be inserted between existing
transformations and removed later without affecting the mappings in the original
process flow. Can also be used to document the process flow for the transformation
so that you can view and analyze the metadata for a user-written transformation,
similarly to how you can for other transformations.

Output Folder
The following table describes the transformations in the Output folder in the Process
Library.

Table A1.5 Output Folder Transformations

Name Description

creates an HTML report that contains selected columns from a source table. See also
“Adding a List Data Transformation to the Process Flow” on page 193.

List Data