Post reply

Best Approach for Delta Load in SSIS

  • March 23, 2012 at 6:52 pm

    #145046

    Been readin about delta load recently (migrating new as well as changed data) and there are different approaches/view from different people such as using checksum, cdc even hashbytes and its all confusing. what is more appropriate method for volumes of data?

  • March 23, 2012 at 7:09 pm

    #1463876

    Have to go with the standard answer here, it depends.

    It depends on how your current data in the source system is stored, how it is stored in the target system. How much duplicate data can you handle or can you handle.

    To give you a better answer we would actually need to know more about your particular environment.

    We can answer your questions, but you'll have to narrow the scope as your initial question is quite broad.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply