Databases Reference
In-Depth Information
Surrogate Key Generator
generates unique key numbers for dimension tables, in a manner that is similar
but less feature-rich than the SCD Type 2 Loader transformation. Use the
Surrogate Key Generator when key generation is the sole task that is required at
that point in the job.
To display Help topics that illustrate how these transformations can be used in SAS
Data Integration Studio jobs, follow these steps:
1
From the SAS Data Integration Studio menu bar, select
Help
Contents
. The
Help window displays.
2
In the left pane of the Help window, select
Examples
Process Library
Examples
. See the examples in the
Data Transforms
folder.
About the SCD Type 2 Loader Transformation
Use the SCD Type 2 Loader transformation to load dimension tables and track
changes to dimension table values. The loader supports Type 2 slowly changing
dimensions. That is, the loader populates special columns in a dimension table that
indicate whether a record is current or historical.
Change Tracking Techniques
The SCD Type 2 Loader supports three different techniques for indicating current
and historical data: effective date range, current indicator, or version number. The
following display shows the
Change Tracking
tab in the properties window for the
SCD Type 2 Loader. This tab enables you to select the technique for tracking changes.
Display 12.1
Change Tracking Tab
In the previous display, the technique
Use beginning and end dates
has been
selected. The Beginning Date is the current date, and the End Date is some point in
Search WWH ::
Custom Search