Regarding Data Mismatching

[Former Member]

Hi gurus,

The Scenario is: Iam extracting data from CRM to BW in both sides Iam using ODS, and every time Iam using initial loads i.e deleting the data every time and loading the fresh data, but I got data mismatch between BW and CRM. The CRM records are lessertham BW records. Can any body give me the possible reasons and solutions for this.

Points will be Awarded.

Thanks&Regards,

Naren.

[Former Member · Accepted solution]

Hi Naren,

It depends upon the structure of ODS, if there is a mismatch in key fields of ODS's these generally happens.

Try creating a multiprovider on this 2 ods and create query on that , one kf from ods1 , one kf from ods2 and see if amount /qty matches.

Hope that helps.

Regards

Mr Kapadia