DTP is getting more records then DataSource/PSA

[Former Member]

Hi Gurus -

I am loading data from same DataSource to BI using mutlple infopackes with different selection.

DataSource1 -> InfoPackage1 ( Selection : 0 - 10 )

DataSource1 -> InfoPackage2 ( Selection : 11- 20 )

DataSource1 -> InfoPackage3 ( Selection : 21- 30 )

These 3 InfoPackages, getting 300K+ records from SAP and putting it on BI PSA.

I have only 1 DTP (Full) to get the data from PSA to put it into DSO. But when data is loading into DSO, it is showing 400K+ records TRANSFFERED which is like 100K+ more then in the PSA. Where it is getting the additional 100K records? However, it is adding 300K records to DSO.

IP1 + IP2IP3 ( 300K records) -> DTP to DSO TRANSFERRED (400K+ ) -> Added to DSO (300K+)

Please help!

-Sonali

[Former Member]

Hi Sonali,

Adding the records in to your DSO will depends on how you design the DSO.

Check for the keys in DSO and if any changes are required please change the keys in DSO.

PSA contains the data in the source system format.

Records transfered : means the records actually transfered into BW.

Records Added are the no of records aggregated based on keys in your DSO or char in cube.

Hope this helps.

Regards,

Reddy

[Former Member]

Hi,

Please check :

-Vikram