Skip to Content
0
Former Member
Nov 06, 2005 at 12:24 PM

ODS design help(SD)

28 Views

Hi,

I need recommendation from the experts regarding an ODS design. I have 3 ODS's (order item, order header and a order-delivery combo ODS. I would like to integrate the data from these 3 ODS's into another ODS. What would be my key fields for this design????? The Key fields for the existing ODS's are given below

1.Order Header- Doc Number

2. order Item- Doc number and item number

3. Order -Delivery- Delivery Number,item number

Thank You