Master data Load - Strategy

[Former Member]

Hi All,

I would like to know the better master data strategy.

When using 3.x master data load strategy I can load directly into the info object without going thru additional DTP process. Is there any specific advantages of doing this, besides that it is 7.X.

I have been using 2004s from 2005 but most of the implementations we used 3.x methodology for master data load and DTP for transaction load. i would like to know whether SAP recommands new methodology using DTP for master data loads? If I load my master data using 3.x I can avoid one extra step, but will it be discontinued in the future? and have to use DTP even for this?

Please advice if you know what is the best way forward strategically an dtechnically?

Thanks,

Alex.

[Former Member]

Hi,

using a 7.0 dataflow for master data loads can have significant advantages, especially for full loads.

In order to optimize loading performance you can extract the master data with parallel running infopackages with non-overlapping selections and store it in PSA. From there you can update it into the data target. With this setup both extraction and update into data target is running with several parallel processes.

With 3.x you had to use the trick mentioned in note 421419, but performance with DTPs is much better.

The extra step for writing data into PSA does in practice not create a performance problem.

Best regards,

Ralf

[Former Member]

Ralf,

I have been doing both for some time now. Loading parallel is something to do with any load not only specific to 3.x or 7.x. My question is not that, Why would I have to use DTP when it can be loaded directly (process chain 1 infopackage to the IOB in 3.x, but 7.x I have to use infopackage followed by DTP). Especially when I use full loads will there be any duplicate issues on the keys (I am facing right now, and we are in development). In 3.x you can do full load with or with out selection with repair option if you are concerned about delta.

Performance measured in terms of parallel load is not available in 7.x, it is independent of versions. Why DTP an extra step when you don't have to for master data. For transaction data you cannot by pass DTP so we have to use.

I hope you understand, my question.

Thanks for your input.

Alex.

[Former Member]

The function of the Infopackage has been limited in 7.0 to only transfer the data from the datasource to the PSA, that's it.

In order to move the data from PSA to Infoproviders or between Infoproviders, you need the DTP. That's its function in the new data flow.

This applies for everything, Master and Transaction data.

[Former Member]

Luis,

Please read my question.

Thanks,

Alex.

[Former Member]

Alex,

Please read my answer...

The new data flow designed by SAP is using the DTP, even for Master Data... Right now you can use the "3.x" style which they maintain for backward-compatibility but down the road, eventually, it will be dropped, so looking ahead, technically and strategically, the right way to go is by using DTP...

You can go here http://help.sap.com/saphelp_nw70/helpdata/en/e3/e60138fede083de10000009b38f8cf/frameset.htm and check under Data Warehousing, Data Distribution, Data Transfer Process...

You could also open an OSS note to SAP and ask them directly.

Thanks,

Luis