SSIS SCD Component
Page 1 of 1
SSIS SCD Component
We are using (or attempting to use) the Kimball Method SSIS Slowly Changing Dimension Component for SSIS from Todd McDermid (http://kimballscd.codeplex.com/).
We have run into a few issues and would appreciate some advice if anyone has used this SSIS component.
First, although, the existing dimension input columns for “SCD2 Current Record”, “SCD2 Effective Date”, and “SCD2 Expiry Date” are assigned on the first tab, when running the job against or test staging table and dimension table, we get no values in these columns.
We have also had difficulty getting the column mapping (tab 2) to stick. (Meaning that the mapping from Source to Existing Dimension doesn’t save the first time and when you open the edit dialogue again some of the mappings are gone.)
Also, we are getting only additional records in our dimension table when using this component, instead of the SCD1 values being changed. We are at a stand-still.
Most of our columns are SCD1 with one exception that is SCD2. There is a single-field surrogate key and a single-field business key.
We have run into a few issues and would appreciate some advice if anyone has used this SSIS component.
First, although, the existing dimension input columns for “SCD2 Current Record”, “SCD2 Effective Date”, and “SCD2 Expiry Date” are assigned on the first tab, when running the job against or test staging table and dimension table, we get no values in these columns.
We have also had difficulty getting the column mapping (tab 2) to stick. (Meaning that the mapping from Source to Existing Dimension doesn’t save the first time and when you open the edit dialogue again some of the mappings are gone.)
Also, we are getting only additional records in our dimension table when using this component, instead of the SCD1 values being changed. We are at a stand-still.
Most of our columns are SCD1 with one exception that is SCD2. There is a single-field surrogate key and a single-field business key.
fdarrigo- Posts : 1
Join date : 2010-03-06
Similar topics
» Looking for suggestions on ETL tools for DW/BI Project
» SSIS newbie
» SCD object in SSIS
» ETL Fact Load in SSIS
» HELP WITH SCRIPT COMPONENET, SSIS
» SSIS newbie
» SCD object in SSIS
» ETL Fact Load in SSIS
» HELP WITH SCRIPT COMPONENET, SSIS
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum