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?
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?
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?
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.
This topic gives an overview of all loaders: SAS(R) Data Integration Studio 4.8: User's Guide
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.