Transformations in 7.0

[Former Member]

Hi,

I have basic doubt. From 3.5 to 7.0, there came a lot of changes and one of the most proclaimed one is the change in Updat Rule/Transfer Rule to Transformations.

Why is this change and what is the exact change in that? Please let me know in simple terms as, wherever I read, I get to know only about the change, but nowhere the exact reason for the change is mentioned.

I would also like to know ODS->DSO and about DTPs.

Also, why do we need to load to PSA first in 7.0.

Regards,

Sam.....

[Former Member]

new NW2004s Data flow

R/3---->PSA only (using Infopackage) for all the Loads -Mandatory

PSA -

---

>ODS/Cube -->load using DTP ,create transformation first

no Datamart architecture in NW2004s

so ODS -

---

>Cube load using DTP ,creating transformation first

Once loaded to PSA in DTP you have the option of FULL or DELTA ,full loads all the data from PSA and DELTA loads only the last load of PSA.

Go through the links for Lucid explainations

Infopackage -

http://help.sap.com/saphelp_nw2004s/helpdata/en/43/03808225cf5167e10000000a1553f6/content.htm

DTP

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/f98e07cc483255e10000000a1553f7/frameset.htm

Creating DTP

http://help.sap.com/saphelp_nw2004s/helpdata/en/42/fa50e40f501a77e10000000a422035/content.htm

Pre-requisite-

You have used transformations to define the data flow between the source and target object.

Creating transformations-

http://help.sap.com/saphelp_nw2004s/helpdata/en/f8/7913426e48db2ce10000000a1550b0/content.htm

ODS to Cube -

http://help.sap.com/saphelp_nw2004s/helpdata/en/ce/dc87c1d711f846b34e0e42ede5ebb7/content.htm

Hope it Helps

Chetan

@CP..

[Former Member]

The ETL process has been changed inn 7.0, rather it is simplified comapre to 3.5.

The exact chnage is this is that direct mapping from DS to datatarget is possible with the help oftransformation. No Tr, UP needed. So so intermidiate steps has been removed.

PSA is mandotory in 7.0 because of that fact that it stores the data temporaraliry and even if further load fails, no need to go to R/3 again to retrieved data. It can always be retrieved from PSA. So performancewise, loadwise and timewise it is good.

For DSO, refer to https://www.sdn.sap.com/irj/sdn/weblogs?blog=/pub/wlg/7168. [original link is broken]

DTP in simple terms, it acts like infopackge in 3.5.

Regards

Pankaj

**********Assign pts if helpful

[Former Member]

Thanks a lot, and points assigned..