Hi ,
We had ODS that is getting updated from 2 ODS . when loading from the first ODS we can see the data in the data fields of the main ODS .
But when loading data from the second ODS it is wiping out the values in the data fields of the main ODS.
I checked all the transformations and don't see the reason why it is happening.
I tried to see if there is any specific pattern. It is happening only with specific key values.
what i mean is if the main ODS is having 100 records . when loading from the second ODS it is wiping out data fields for only 10 records of the total 100.
Before activation i can see the data in the new table.
Is there a way we can debugg the activation process?
any thoughts? any ideas?
Thx,
Ravi.