BookmarkSubscribeRSS Feed
🔒 This topic is solved and locked. Need further help from the community? Please sign in and ask a new question.
eagles_dare13
Obsidian | Level 7

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?

1 ACCEPTED SOLUTION

Accepted Solutions
DaveR_SAS
SAS Employee

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?

View solution in original post

3 REPLIES 3
DaveR_SAS
SAS Employee

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
Obsidian | Level 7

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.

sas-innovate-2024.png

Available on demand!

Missed SAS Innovate Las Vegas? Watch all the action for free! View the keynotes, general sessions and 22 breakouts on demand.

 

Register now!

How to connect to databases in SAS Viya

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.

Discussion stats
  • 3 replies
  • 2236 views
  • 5 likes
  • 2 in conversation