Skip to Content
Former Member
Dec 18, 2007 at 07:38 PM

Selective ODS deletion


Hi guys,

We did our technical upgrade from 3.5 to 7.0.

Basically we have a datamart ODS_T (target ODS) which is fed by two ODS' named ODS1 and ODS2 DAILY. ODS1 feeds only Delta to ODS_T but ODS2 feeds a Full Update to ODS_T. So basically there are 2 new requests sitting in the (manage Data target) ODS_T everyday, one from ODS1 (Delta) and the other one from ODS2(Full). Now as per the business requirement, we want to delete the Full update request (which is coming from ODS2) everyday in ODS_T before loading the new request from the same, while keeping the Delta request (which is coming from ODS1) as it is in ODS_T. How do we go about doing it.?

Meaning lets say affter 10 days we would see 10 requests which came from ODS1 as Delta sitting in ODS_T but only 1 request which came from ODS2 sitting in ODS_T

Any comment and idea would be appreciated.