Hi,
Transformation workks like a bridge between two objects, it can be compared with the infosource or update rules in the BW3.X.
You can create a transformation from the datasource to any infocube or a infoobject or an ODS. right click on the datassource & select create transformation from the context menu.
Data transfer process or DTP is like an info package in the earlier versions. A DTP is used to load data with in the BI system you use a DTP to load data through transfromation.
You create DTP for a Transformation.
Go through this link....
http://help.sap.com/saphelp_nw2004s/helpdata/en/42/f98e07cc483255e10000000a1553f7/frameset.htm
Below are the basic steps which we follow in any BI 2004S system:
1)Create datasource. Here u can set/check the Soucre System fields.
2)Create Transformation for that datasource. (no more update rules/transfer rules)
2.1) While creating transformation for DS it will ask you for data target name, so just assign where u want to update ur data.
DataSource -> Transformation -> Data Target
Now if you want to load data into data target from Source System Datasource:
1) Create infopackage for that data source. If you are creating infopackage for new datasources, it will only allow you update upto PSA, all other options u can see as disabled.
2)Now Create DTP (Data Transfer Process) for that data source.
3) NOw schdule the Infopackage, once the data is loaded to PSA, you can execute your DTP which will load data to data target.
If you are loading data from one one data target to other, no need to use PSA, you can directly execute DTP in that case.
Data Source -> Transformation (IP/DTP) -> Data Target1 -> DTP ->Data Target 2
Use the below link for detailed example:
https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/fc61e12d-0a01-0010-2883-e2f...
Hope it Helps,
Thanks,
Happy Life,
Aravind
Bluesky
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.