Skip to Content
avatar image
Former Member

Question about delta inistialization

Hi experts,

If someone deleted by mistake the request of delta initialization option for source system. And i recreate this request without data transfert option.

Is there any risk to loose some delta records?

Thanks.

Amine

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • Best Answer
    Oct 19, 2015 at 12:35 PM

    Hi Amine

    Yes, there is a possibility of missing some delta records, because data created in source system after this INIT will only be fetched during the next Deltas to BW system.

    So the transactions created during this time will be lost.

    It is also based on the time when the first initialization request was deleted and the next one gets created.

    But the more you wait, the more data will be lost. So load init w/o data as you have planned and reconcile the target data to the source.

    If any data is missed, fill the setup table accordingly and run a full repair without disturbing the delta records.

    Regards

    Karthik

    Add comment
    10|10000 characters needed characters exceeded

    • Hi,

      if recreate the immedetely no issue with data.but you need to do this actvity non business hours and better do in weekends.

      if you want reinit again pelase lock the users, user not to do any positing in source side.

      better lock the user and take help form the basis team (how to lock the users)

      Thanks,

      Phani.

  • avatar image
    Former Member
    Oct 19, 2015 at 02:51 PM

    Hi Amine,

    The delta will be lost.even if you have deleted the init and created it immediately.

    what ever delta records which were available in the delta Queue is is not considered for the next delta load when you delete the init. On performing the reinit a new pointer is set. In effect the delta records are lost.

    Hence you can wait for the next delta and check whether there is any delta which is missed. if yes then you have to fill in the setup tables and bring the data into BW

    Regards

    Vivek

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 19, 2015 at 02:57 PM

    Thanks guys for your answers.

    There are come contradictory answers, but we will see 😊

    Amine

    Add comment
    10|10000 characters needed characters exceeded