cancel
Showing results for 
Search instead for 
Did you mean: 

How to design data load process chain?

Former Member
0 Kudos

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

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

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

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

You might have a look on:

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

Useful docs...

LauQ

Former Member
0 Kudos

-- 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?

Former Member
0 Kudos

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