Thursday 15 March 2012

DTP(Data Transfer Process) - 2

Data transfer process is new comes with SAP BI 7.0. Using Data transfer process 
we can improve the loading process, filtering, error handling etc. 

Data transfer process (DTP) loads data within BI from one object to another object
with respect to transformations and filters. DTP is used to load the data from 
Persistent Staging Area (PSA) to data targets.

Data transfer process (DTP) loads data within BI from one object to another object with respect to transformations and filters. 

DTP is used to load the data from Persistent Staging Area (PSA) to data targets.

The data transfer process makes the transfer processes in the data warehousing layer more transparent. 

We can use the data transfer process to separate delta processes for different targets.

We can use filter options between the persistent objects on various levels. For example, we can use filters between a Data Store object and an Info Cube.

We can not schedule background in data transfer process directly, we must use process chain to active this.


Types of Data Transfer Process:

1. Standard DTP
2. Real-time Data Acquisition (RDA).
3. Error DTP
4. Direct Access DTP


Advantages:
  • Data can be loaded from one layer to others except Info Sources.
  • DTP can load Full/Delta load for same target via same DTP which is not possible via same Info Package.
  • Separation of delta mechanism for different Data Targets is possible in data transfer process.
  • Data transfer process filters data only at Data Target level by keeping all data at Persistent Staging Area(PSA).
  • Error handling improves in data transfer process using Error stack.
  • DTP is faster as DTP data loading is optimized by Parallel process.
  • Break point can be set at data packet level at all the stages in data transfer process but break point doesn't exist in Info Package.

No comments:

Post a Comment