Hi
I'm loading data in this manner.
DSO1 -> CUBE -> DSO2
Data in DSO1 is correct and data in CUBE is also correct. While moving the data from CUBE to DSO2, the delta mechanism is not working fine. Especially the first initial load which contains both New Image, Before Image and After Image. As we don't have RECORDMODE in cube, the DSO2 is not able to pick the After Image and randomly picks anyone of the 3 records and considers it as the latest record.
Suppose changelog of DSO1 contains below records:
MATERIAL QTY RECORDMODE
S1 10 N
S1 -10 X
MAT001 10 ' '
The records in DSO2 should show MAT001 but it doesn't pick that. But the data in cube is fine.
Now, my doubt is, if I map 0RECORDMODE from DSO1 to CUBE to DSO2, will it work?
Regards
Murthy