Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Change Tracking

Отвечено Change Tracking

  • Wednesday, November 21, 2012 11:55 AM
     
     
    Sign In to Vote
    0

    Hi

    I am tasked with populating dimension tables for a data warehouse.

    I want to use change tracking to feed data into a slowly changing dimension component within an ssis package. Is this a valid solution or is there a better alternative?

    Ross

     

All Replies

  • Wednesday, November 21, 2012 2:31 PM
     
     Answered
    Sign In to Vote
    0

    Yes, change-tracking can be used in conjunction with the slowly changing dimension component within SSIS.  Change Data Capture is an alternative, but if Change Tracking is already configured on your source system(s), I wouldn't bother changing that up.  Here's a quick comparison of CT vs CDC.

    Not sure if this is up for debate, but there are also alternatives to using the standard Slowly Changing Dimension component in SSIS.  This component has been shown to perform terribly with large dimensions..

     
  • Friday, November 23, 2012 1:21 PM
     
     Answered
    Sign In to Vote
    0
    Your task is to populate Dimension. For this you need to determine what type of SCD is it.. is it TYPE1 or TYPE 2 or TYPE 3, Based on that you need to 
    strategies the approach. you can go with CHECK SUM or insert else update approach depending upon the volume.

    SQL Champ
    Database Consultants NY