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