Can some one help me with the below scenario :
A delta load from the source system is done to an ODS and subsequently the delta is passed to the cube.
Once the load is done, we compare the number of records in the ODS with the number of records in the source system.
But everyday we find a mismatch of 1 record for a particular extract. then we follow the below procedure to match the records :
*Selective delete from the ODS for the month and extract for which the mismatch is found
Selectively do a Full repair load to ODS.
Activation of ODS.
Selective delete from the cube for the month and extract for which the mismatch is found
Selectively do a Full repair loads to cubes followed by a Init with out data transfer to cube.*
When we do this procedure the record count in the BW and Source system match.
My Question is Why do we get a mismatch of 1 record for a particular extract everyday?? What can be the possible reason for this and wat is the action to be taken.
Secondly when we follow the above given procedure, how does the data match??
Kindly let me know if you need more information.
Appropriate Points will be Rewarded.
Thanks in Advance!!!