ODS Update / Insert / Delete

106 Views

HI.

I have 2 ODS's with the same structure. The key to these ODS's is customer,material and month.These ODS's are populated with data from different sources. If for the same combination of customer,material and month data comes for both ODS's then the 2nd ODS has the most reliable data.

For example,for ODS 1 if the data is

CUST MAT MONTH QTY

customer1 material1 022005 60

customer1 material2 022005 70

customer1 material3 022005 50

and for ODS 2 if the data is

CUST MAT MONTH QTY

customer1 material1 022005 40

customer1 material2 022005 80

The final valid data is

CUST MAT MONTH QTY

customer1 material1 022005 40

customer1 material2 022005 80

The data loaded from the 1st ODS must be overwritten and if there are any extra records they must be deleted.

Any ideas on how to implement this? I dont think we can use 0recordmode for this?

Pls help. Any direction in this regard would be of great help.

Suja