SCD Type 2 Loader vs Change Data Capture

[eagles_dare13]

SAS DI Studio has these two transformations:

1.Change Data Capture

2.SCD Type 2 Loader

Are these two related? In what ways are they different?

[DaveR_SAS · Accepted solution]

This topic describes all production transformations and includes links to related doc: SAS(R) Data Integration Studio 4.8: User's Guide

This overview topic describes how Change Data Capture and Slowly changing dimensions are related:

SAS(R) Data Integration Studio 4.8: User's Guide

Does that help?

[eagles_dare13]

Thanks. Actually my question should have been...what is the difference between a normal Table Loader and a SCD Type 2 Loader. They both load Data from a source table to a target table.

[DaveR_SAS]

This topic gives an overview of all loaders: SAS(R) Data Integration Studio 4.8: User's Guide