How to achieve the output from DS8.1
Posted: Thu Aug 26, 2010 7:44 am
Hi Expert,
I am unable to achieve below scenario.
Dataset contains( This is Driver dataset)
Id Date
---- --------------
1 01-01-10
1 04-02-10
1 06-05-10
1 10-06-10
Table is contining below data
Id Date Name
---- -------------- ------------
1 01-01-10 Rick
1 05-02-10 Symon
1 05-05-10 Roger
1 10-06-10 Mark
Both place ID and Date is Key field.
Output Must be
----------------------------
1 01-01-10 Rick 01-01-10
1 04-02-10 Rick 01-01-10
1 06-05-10 Roger 05-05-10
1 10-06-10 Mark 10-06-10
I am using datastage 8.1. It would be highly appreciate for your help.
thanks,
Surya
I am unable to achieve below scenario.
Dataset contains( This is Driver dataset)
Id Date
---- --------------
1 01-01-10
1 04-02-10
1 06-05-10
1 10-06-10
Table is contining below data
Id Date Name
---- -------------- ------------
1 01-01-10 Rick
1 05-02-10 Symon
1 05-05-10 Roger
1 10-06-10 Mark
Both place ID and Date is Key field.
Output Must be
----------------------------
1 01-01-10 Rick 01-01-10
1 04-02-10 Rick 01-01-10
1 06-05-10 Roger 05-05-10
1 10-06-10 Mark 10-06-10
I am using datastage 8.1. It would be highly appreciate for your help.
thanks,
Surya