topic Re: SCD Type 2 Loader vs Change Data Capture in SAS Data Management https://communities.sas.com/t5/SAS-Data-Management/SCD-Type-2-Loader-vs-Change-Data-Capture/m-p/136423#M2009 <HTML><HEAD></HEAD><BODY><P>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. </P></BODY></HTML> Thu, 09 Jan 2014 19:33:59 GMT eagles_dare13 2014-01-09T19:33:59Z SCD Type 2 Loader vs Change Data Capture https://communities.sas.com/t5/SAS-Data-Management/SCD-Type-2-Loader-vs-Change-Data-Capture/m-p/136421#M2007 <HTML><HEAD></HEAD><BODY><P>SAS DI Studio has these two transformations:</P><P>1.Change Data Capture</P><P>2.SCD Type 2 Loader</P><P></P><P>Are these two related? In what ways are they different?</P></BODY></HTML> Thu, 09 Jan 2014 16:32:13 GMT https://communities.sas.com/t5/SAS-Data-Management/SCD-Type-2-Loader-vs-Change-Data-Capture/m-p/136421#M2007 eagles_dare13 2014-01-09T16:32:13Z Re: SCD Type 2 Loader vs Change Data Capture https://communities.sas.com/t5/SAS-Data-Management/SCD-Type-2-Loader-vs-Change-Data-Capture/m-p/136422#M2008 <HTML><HEAD></HEAD><BODY><P>This topic describes all production transformations and includes links to related doc: <A href="http://support.sas.com/documentation/cdl/en/etlug/66819/HTML/default/viewer.htm#n0geesvp950nken1tetx8ffwoxkt.htm" title="http://support.sas.com/documentation/cdl/en/etlug/66819/HTML/default/viewer.htm#n0geesvp950nken1tetx8ffwoxkt.htm">SAS(R) Data Integration Studio 4.8: User's Guide</A></P><P></P><P>This overview topic describes how Change Data Capture and Slowly changing dimensions are related:</P><P><A class="active_link" href="http://support.sas.com/documentation/cdl/en/etlug/66819/HTML/default/viewer.htm#n19c0oaircimzbn1nlrrt9vmlnjr.htm" title="http://support.sas.com/documentation/cdl/en/etlug/66819/HTML/default/viewer.htm#n19c0oaircimzbn1nlrrt9vmlnjr.htm">SAS(R) Data Integration Studio 4.8: User's Guide</A></P><P></P><P>Does that help?</P></BODY></HTML> Thu, 09 Jan 2014 16:40:25 GMT https://communities.sas.com/t5/SAS-Data-Management/SCD-Type-2-Loader-vs-Change-Data-Capture/m-p/136422#M2008 DaveR_SAS 2014-01-09T16:40:25Z Re: SCD Type 2 Loader vs Change Data Capture https://communities.sas.com/t5/SAS-Data-Management/SCD-Type-2-Loader-vs-Change-Data-Capture/m-p/136423#M2009 <HTML><HEAD></HEAD><BODY><P>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. </P></BODY></HTML> Thu, 09 Jan 2014 19:33:59 GMT https://communities.sas.com/t5/SAS-Data-Management/SCD-Type-2-Loader-vs-Change-Data-Capture/m-p/136423#M2009 eagles_dare13 2014-01-09T19:33:59Z Re: SCD Type 2 Loader vs Change Data Capture https://communities.sas.com/t5/SAS-Data-Management/SCD-Type-2-Loader-vs-Change-Data-Capture/m-p/136424#M2010 <HTML><HEAD></HEAD><BODY><P>This topic gives an overview of all loaders: <A href="http://support.sas.com/documentation/cdl/en/etlug/66819/HTML/default/viewer.htm#n1ojj01d4830jpn158d5w5jtlu9w.htm" title="http://support.sas.com/documentation/cdl/en/etlug/66819/HTML/default/viewer.htm#n1ojj01d4830jpn158d5w5jtlu9w.htm">SAS(R) Data Integration Studio 4.8: User's Guide</A></P></BODY></HTML> Thu, 09 Jan 2014 19:42:41 GMT https://communities.sas.com/t5/SAS-Data-Management/SCD-Type-2-Loader-vs-Change-Data-Capture/m-p/136424#M2010 DaveR_SAS 2014-01-09T19:42:41Z