ODS design

Hi

I need to design a ODS based on ods1 and ods2.

Below is the example.

Can any one suggest me the best way of doing it.

oDS1

K1 k2 PD CN Units

11 22 p1 c1 10

12 23 p2 c2 20

13 24 p3 c3 30

K1 K2 are the keys and the remaing are the data fields.

OdS2

CN OC Dummy KF

C1 O1 123

C1 O2 123

C1 O3 123

C2 O1 123

C2 O2 123

c3 o2 123

c3 O3 123

In this C1 O1 are the keys and the Dummy Kf (of no use) is the data field.

my result ODS should be

K1 K2 PD CN OC Units

11 22 P1 C1 O1 10

C1 O2 10

C1 o3 10

12 23 P2 C2 O1 20

C2 O2 20

13 24 P3 C3 O2 30

C3 o3 30

Here the unit field is filled based on the ods1.

Thx.