DSO Design

[Former Member]

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.

[Former Member]

Hi Eric ,

This is happening coz in ur example day,shift and product are two different combination.see below example

day product shift

010107 678 4

010107 4

day-010107, product-678 and shift-4 is a key combination similarly day-010107,product-blank and shift-4 is also a different combination thats why it is duplicating the record. if u dont want to maintain blank record for any key then u can write a routine to delete the records for blank keys.

hop this would help!!

Regards

Amit