September 8, 2008 at 10:07 am
How can we resolve type 3 slowly changing dimension problem in SSIS. Type 1 and Type 2 are easily possible using Slowly Changing Dimension Transformation changing attribute and historical attribute.
FYI - Type 3 will require additional column to track column level changes. e.g. First_City and Current_City. First city will never be modified. If a person' address is changed from one city to another, Current_City will be modified.
Type 3 change can be handled through stored procedure or T-SQL code, but is there any easy way to handle it in SSIS?
Appreciate any help!
Regards - JL
September 8, 2008 at 10:14 am
Ignore the "First" fields when you set up the SCD wizard. Allow the wizard to set them to NULL when it inserts a record and have it do nothing when it updates a record.
Then, go back to your table definition, set up an INSERT trigger to set the "First" version of each of the fields to the "Current" version.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply