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