ETL projects for Slowly Changing Dimensions
Common SCD scenarios and how these scenarios
are implemented using ETL projects and jobs.
- Overview
Slowly changing dimension is a common data warehousing scenario. SCD utilizes three different method types for handling changes to columns in a data warehouse dimension table.
- Case Study Scenario
A case study scenario for type 2 SCD and information on how to create transformation projects in ETL to implement this scenario.
- Setting up ETL projects for SCD
Review the ETL concepts for accomplishing type 2 SCD using projects and jobs. The demo repository that is packaged with the product includes various transformation objects related to the type 2 use case, including:
Created May 24, 2011. Send feedback on this help topic to Sybase Technical Publications:
pubs@sybase.com