Skip to Content
0
Former Member
Feb 02, 2007 at 09:07 AM

Deletion of data in ODS without disturbing Delta

11 Views

Hi,

This is my scenario:

Init + delta

-


> CUBE A

ODS A -


> ODS B

-


> ODS C

Delta has been initialized and is flowing every nite from the ODS A into the three Datatargets shown above(via the PSA).

Now there is a defect in the update rule of ODS B and i have to change the update mode of all KF to addition(it was overwrite before).

For correct data to be populated in ODS B, i have to delete the contents of the ODS B and load the data again without disturbing the delta, as the data in the ODS A is massive - 2 million records.

My question is - can I delete the data from the ODS A and run a Full Load to ODS B , without disturbing the delta administration?

If i do this, Will delta from ODS B to CUBE A and ODS C also fail.

Can anyone tell me the exact proces and how to achieve this scenario?

thnks in advance

Dhanya.