Skip to Content
avatar image
Former Member

Combining delta and full loads

Hello experts,

Delta initialization is often very time consuming that might become a problem since there should not be any postings in OLTP during the load. This can be alleviated by:

- Performing delta init only for the current year/period onwards and

- Executing separate full loads for the previous years/periods

Is there any hidden dangers in doing this? Or should we always make a full delta init?

Thanks,

Tuomas

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    avatar image
    Former Member
    Sep 02, 2008 at 06:52 AM

    Hi Tuo,

    If you are very sure the data you are full loading will never change, then there are no dangers.

    Lets say u are very sure that there will not be any change for data corresponding to the year 2005.

    So you can do a full upload for this data.

    But if there is any change in this data in the future that cannot be reflected in BI.

    Hope this helps

    Cheers

    Jayashree.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 02, 2008 at 08:19 AM

    Hi,

    When you load data with full update it will pick all the records till date, but in delta loads modified and newly added records will update.

    Add comment
    10|10000 characters needed characters exceeded