on ‎2007 Mar 19 12:18 PM
What is Data Transfer process in BI 7?
How to use it?
I am new to BI 7.....
Inputs are appreciated....
Request clarification before answering.
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
transformation is the one where you will map the fields between your data target and the corresponding data source. its just the equallent process like transfer structure and communication structure in 3.5.
data transfer process will just execute the data loading process. here we have to specify the type of extraction mode(delta or full)
http://help.sap.com/saphelp_nw2004s/helpdata/en/42/f98e07cc483255e10000000a1553f7/frameset.htm
Hareesh
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
DTP is nothing but dta transfer process, which it works like an ipack,
with dtp extract data from ds, execute & load the data into particular
target
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
DTP Takes care of putting data in IC/DSO as the infopackage is working only till Datasource/PSA level,
After that the data is moved through transformation and DTP.
Transformation rules map any number of source fields to at least one target field.
DTP uses a datasource as source and DSO/Infocube as target
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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:
Hope it Helps,
Thanks,
Happy Life,
Aravind
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You use the data transfer process (DTP) to transfer data within BI from a persistent object to another object in accordance with certain transformations and filters
It is like a replacement of the info packages in the olderr versions.
Data transfer processes are used for standard data transfer, for real-time data acquisition, and for accessing data directly.
youu can refer to this link for mor infos.
http://help.sap.com/saphelp_nw2004s/helpdata/en/42/f98e07cc483255e10000000a1553f7/frameset.htm
regards.
Message was edited by:
RamaSubramanian Gurunathan
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
| User | Count |
|---|---|
| 7 | |
| 6 | |
| 5 | |
| 4 | |
| 4 | |
| 4 | |
| 3 | |
| 3 | |
| 3 | |
| 2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.