Skip to Content
0
Former Member
Nov 25, 2009 at 04:51 PM

Delta load for DSO

17 Views

HI All,

I have an issue:

we have 2 DSOs :

DSO1

CustID(key) qty

C1 50

DSO2

CustID MatID REV

C1 M1 500

I want to see in DSO3: as a single record:

CustID(KEY) MID(KEY) QTY REV

C1 M1 50 500

Not two records...like the below

CustID(KEY) MID(KEY) QTY REV

C1 50

C1 M1 500

-


DSO1 and DSO2 are delta loads daily..may be same records? or different delta records?

Question:

How to get delta records for DSO3 if my DSO2 Delta records are different than DSO1 delta records?

Please advise me ...for the best solution..

Thanks,

Surya