Skip to Content

How to do "early delta initialization" in ODP-enabled DTP

Hi guys,

This is for 2LIS extractors......Since we don't need a downtime of ECC for using "early delta initialization" in infopackage, can we also do the same in DTP which is ODP-enabled?

So these are the steps when doing the "early delta initiliazation" setup in INFOPACKAGE:

1) Run the Info Package with the option "early delta initialization".

2) Delete the data in setup tables for specific application component.

3) Fill the setup tables.

4) Load the setup tables data to BW using full repair INFOPACKAGE.

5) Run DELTA INFOPACKAGE for the next DELTA data.

Just want to clarify if we can also do the "early delta initialization setup" in ODP-enabled DTP?

Which of these are correct???

OPTION1

1) Run the DTP with DELTA option delta init without data.

2) Delete the data in setup tables for specific application component.

3) Fill the setup tables.

4) Load the setup tables data to BW using DELTA DTP.

5) Run DELTA DTP for the next DELTA data.

OPTION2

1) Run the DTP with DELTA option delta init without data.

2) Delete the data in setup tables for specific application component.

3) Fill the setup tables.

4) Load the setup tables data to BW using FULL DTP.

5) Run DELTA DTP for the next DELTA data.

OPTION3

1) Delete the data in setup tables for specific application component.

2) Fill the setup tables.

3) Load the setup tables data to BW using DELTA DTP.

4) Run DELTA DTP for the next DELTA data.

OR

What are the correct steps to do it? From what I read, if we will be using ODP-enabled DTP, we still need to have a downtime in ECC. Is that correct? Something like this:

1) Downtime in ECC.

2) Delete the data in setup tables for specific application component.

3) Fill the setup tables.

4) Load the setup tables data to BW using DELTA DTP.

5) Run DELTA DTP for the next DELTA data.

Thank you,

Loed

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • Oct 09, 2018 at 06:38 AM

    Any idea guys?

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 10, 2018 at 09:14 PM

    Hello,

    Actually I have many ideas, but I need to understand what you mean by downtime in this scenario? As long as delta data is not created or requested by any user or application during this process of setting up the DataSource, I don`t see why would happen a downtime. What I would do automatically would be -

    1. replicate datasource in BW

    2. trigger delta init using ODP connection to respective Source System.

    3. fill the setup table and do a full load.

    this is not the only option though.. you can fill setup table and then do the delta init with data transfer. Feel free to elaborate so I can help further.

    Cheers!

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 05 at 11:08 AM

    Any help on this one?

    Thank you.

    Loed

    Tania Ribeiro

    Add comment
    10|10000 characters needed characters exceeded