SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

SCD Type 2 Loader vs Change Data Capture

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 82
Accepted Solution

SCD Type 2 Loader vs Change Data Capture

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?


Accepted Solutions
Solution
‎01-09-2014 11:40 AM
SAS Employee
Posts: 75

Re: SCD Type 2 Loader vs Change Data Capture

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


All Replies
Solution
‎01-09-2014 11:40 AM
SAS Employee
Posts: 75

Re: SCD Type 2 Loader vs Change Data Capture

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?

Frequent Contributor
Posts: 82

Re: SCD Type 2 Loader vs Change Data Capture

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 Employee
Posts: 75

Re: SCD Type 2 Loader vs Change Data Capture

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

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

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