Necessary steps for a daily delta load

What are the steps that should be taken for a delta load? I am trying to do an "init without data transfer". I was doing "full loads" of till data up until the previous month and now I am starting with delta loads. Eventually I want to include daily delta loads in the process chain. Will you help me?

    Requires Free Membership to View

If you are planning to do delta loads without data transfer, you will have to make sure that the full load and delta loads are in sync. This means there is a possibility that you will load duplicate records or even miss some of the records if not preformed properly. The best way to do this is to do all the full loads up to the current day at a quiet time, and then do the delta init.

This was first published in May 2007

Join the conversationComment

Share
Comments

    Results

    Contribute to the conversation

    All fields are required. Comments will appear at the bottom of the article.