In start routine soure_package is not displaying all the records of source

[Former Member]

Hi ,

i have a trasformation from DSO -> Open hub

in the start routine written some logic

To test that code break point was set on source_package but here in debug mode iam able to

see source_package data (some records of the source data were missing)even i have checked the DSo active table its contains 25000 records but in soruce_package it s showing 160 records.

pls anyone advise me where iam missing how to get all the records of DSO i want it in source_package.

Regards

[Former Member]

Hi Vaishnu,

Check if you are doing full load or Delta load in your case as mentioned by Suman in the earlier post. If its a full load check where the data is getting picked from i.e. is it from active table or change log table. Also see that the structure of the DSO and the Open hub are same or not. If its not same then in that case your number of records will not be same in DSO and Open Hub.

Regards,

Satyam

[Former Member]

Hi Vaishnu,

You can check on the folowing points :

1) have you maintained any filter in your DTP level ?

2) What is the Package Size setting in your DTP level .... is it 160 ?

Kindly check on the above points .

Hope the above reply was helpful.

Kind Regards,

Ashutosh Singh

[Former Member]

Hi Ashuthosh,

Thanks for ur reply .package size is 25000 only.

and no filters was set in dtp.

Regards

[former_member182470]

Hi,

I think you are trying to do delta load from DSO. That might be the reason behind the data which is picking by souce_package is only 160 records instead of 25000.