Skip to Content
author's profile photo Former Member
Former Member

How to design data load process chain?

Hello,

I am designing data load process chains for the first time and would like to get some general information on best practicies in that area.

My situation is as follows:

I have 3 source systems (R3 and two for which I use flat files).

How do you suggest, should I define one big chain for all my loading process (I have about 20 InfoSources) or define a few shorter e.g.

1. Master data R3

2. Master data flat file system 1

3. Master data flat file system 2

4. Transaction data R3

5. Transaction data file sys 1

.....

... and execute one after another succesful end?

Could you also suggest me any links or manuals on that topic?

Thank you

Andrzej

Add a comment
10|10000 characters needed characters exceeded

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on May 12, 2005 at 12:11 PM

    Andrzej,

    My advise is to make separate chains for master & transaction data (always load in this order!) and afterwards make a 'master chain' where you insert these 2 chains one after the other (so: Start process -> Master data chain -> Transaction data chain).

    Regarding the separate chains; paralellize as much as possible (if functionally allowed). Normally, the number of parallel ('vertical') chains equals the nr of CPU's available (check with basis-person).

    Hope this provides you with enough info to start off with!

    Regards,

    Marco

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 12, 2005 at 11:04 AM

    -- It depends if this is a initial load or regular load.

    -- Are you going to load all the master data even from the flat file regularly?

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello,

      I have already made initial load manually and now I want to design loading schema for delta.

      I do not have big volunes of master data (at most 300 records) and majority of them are updated with full update.

      My R3 transaction data volume is about 500 records

      and flat files are about 4000 records.

      I am planning to upload them monthly.

      Regards,

      Andrzej

  • author's profile photo Former Member
    Former Member
    Posted on May 12, 2005 at 11:56 AM

    Hi,

    You might have a look on:

    https://websmp205.sap-ag.de/bi -> SAP BW InfoIndex -> Process Chains

    Useful docs...

    LauQ

    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.