Skip to Content

Init without data transfer & Full load or Init with data transfer?

In which case (in point 3 below), I should go for Full load and Init load with data transfer? I already checked in the forum but still, I have a confusion.

EX: If I enhanced 2 fields in ECC (Say LO data-source), and I have historical data in BW. Now, I want historical data(3 years) in those 2 fields too and DSO in the flow. (Data-source -> Infocube)

Steps:

1) Delete all data from the cube.

2) Fill setup tables

3) Do init without transfer and then full load. (So, the pointer will set first and while full load if any posting happen, it will sit in delta queue)

OR

3) Init with data transfer and then Delta update.

Note: No Downtime.

which is the best approach?

(Points will be assigned for correct answer)

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Posted on Jul 28, 2020 at 04:07 AM

    Hi, in my experience i recommend you to choose the option of init delta with data, but the initialization must be done with the system locked.

    This is because if the time of load (if its huge) is a time in that users can add new records that would not be loaded in the init process.

    By example if the init with data took 2 hours, every additional document created in this two hours would not be included in the init process and could be lost of your extraction process.

    Now i have a third option, that is load with data and then load a full load only of that day and cover the possibly other documents not loaded in the init process.

    Execute this full load and overwrite the records in the DSO and with this you can be sure that all the data is loaded combining the init and this full load both should have all the history of the datasource.

    After that you only have to load the daily deltas wwithout problems.

    I hope this help you.

    Regards.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.