Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

How to implement scd in SSIS(2008) without SCD or CDC transformation. Expand / Collapse
Author
Message
Posted Tuesday, March 25, 2014 11:10 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, April 17, 2014 9:17 PM
Points: 8, Visits: 30
Hi,
How can we capture changed data and new data in SSIS without SCD trasformation.Will we use SCD transformation in realtime or will follow any other methology(like using LookUp,ConditionSplit).Please let me know the process.

Thanks
Post #1554600
Posted Wednesday, March 26, 2014 1:35 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, December 17, 2014 7:15 AM
Points: 3, Visits: 49
I wrote up how to use the HASH function to determine changes. Also, performs much faster then SCD.

http://anexinetbi.blogspot.com/2013/04/faster-slowly-changing-dimension-with.html
Post #1555147
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse