We are trying to fill in missing rows among three tables.
For Ex: The present scenario
Code: Select all
TABLE A TABLE B TABLE C
ID,Date,Amt ID,Date,Amt ID,Date,Amt
10000003,1/31/2004,100.00 10000003 1/31/2004,120.00 10000003,1/31/2004,90.00
10000003,2/28/2004,200.00 10000003,2/28/2004,145.00
10000003,3/31/2004,130.00
10000003,4/30/2004,110.00 10000003,4/30/2004,140.00
Code: Select all
TABLE A TABLE B TABLE C
ID,Date,Amt ID,Date,Amt ID,Date,Amt
10000003,1/31/2004,100.00 10000003 1/31/2004,120.00 10000003,1/31/2004,90.00
10000003,2/28/2004,200.00 10000003,2/28/2004,145.00 10000003,2/28/2004,90.00
10000003,3/31/2004,200.00 10000003,3/31/2004,145.0 10000003,3/31/2004,130.00
10000003,4/30/2004,110.00 10000003,3/31/2004,145.0 10000003,4/30/2004,140.00
How do we go about doing this in DataStage.
Thanks !
dsrules