ODS - Overwrite

Hi

I have a ODS1 where wk and mtrl are keys.

ODS1

Week1 mtrl Qty

w1 m1 10

w2 m2 40

w2 m1 30

I would like to update (overwrite) this ODS with another ODS, say ODS2.

ODS2

w2 m2 20 (this ODS will have all W2's only )

W2 m3 30

My result (in ODS1) should be

w1 m1 10

w2 m2 20 (over write)

w2 m3 30 (overwrite)

W2 m1 0 (As there is no value for W1 m1 in

the 2nd ODS i should overwrite the

W2 m1 with '0').

Did any one face this type of situation?

Thanks.