DSO Design

Hi All,

My requirement is to extract the data from two datasources to DSO. The granularity in two datasources are different i.e. one datasource is on product and day level and other datasource is on shift and day level granular. DSO is on shift, Product and day based. When I load data from 2 sources to DSO there will be 2 records for same shift combination with blank product and product value. Would anyone explain me how to design the DSO to fulfill these reqiuerement, thanks in advance.

Example data:

Calday Plant machine product shift kyf1 kyf2

010107 23 456 678 4 100 200

010107 23 456 4

Regards

Eric.