Question:
Hello,
BW Experts :
One more question with above question.
I have checked the monitor of my load to ODS it shows 2million records of 2 million Records loaded.But when i check the data in the ODS from Active data table,Number of entries it shows me only 70,000 Records availabel.Please advise me where did the rest of the data go.Is there any way to find the data by comparing to Monitor to Data loaded in Active table.
Thanks in advance,
Yoko.
Answer:
Hi ,
My guess is ,
U know ODS do overwrite , suppose if u have multiple records for the key fields , only the latest record will get update in Activate Table unlike in change log table of ODS .. so out of 2 million records , some of the recrods would have multiple records with same keyfield , that could have given u only 70K records in Active table .
Confirm !
regards
Answer:
Yes! you are true it has aggregated based on KEY fileds.
Thanks for your help.