Skip to Content
0
Former Member
May 27, 2008 at 06:39 PM

Data disaapearing after activation

24 Views

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.