February 29, 2012 at 9:15 pm
Has anyone ever implemented a Type 4 Slowly Changing Dimension in SSIS? With any method (SCD Wizard, Kimball SCD Component, or other method)? I understand the concept of keeping historical records in a separate table, and have implemented Type 2 (history in the same table). Thanks in advance!!
March 1, 2012 at 8:04 am
A type 4 SCD is defined as basically history tables.
Neither the SSIS SCD Wizard or the Kimbal SCD component supports type 4 SCDs.
Is this for a data warehouse? If so I would not use a type 4 I would use a type 2. If not it is not usual for this to be handled either be triggers, CDC, or replication. I don't think I would use SSIS.
CEWII
March 1, 2012 at 2:33 pm
Thanks for the reply Elliott. My gut feeling when I saw the model, was exactly that. Why do I need these history tables? I've implemented Type 2 on numerous occasions, and have been successful at it. I think that I will look into a CDC solution.
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply