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
How to achieve the output from DS8.1
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 6
- Joined: Tue Jun 15, 2010 11:17 am
-
- Participant
- Posts: 342
- Joined: Tue Nov 04, 2008 10:38 am
- Location: Chennai, India
-
- Participant
- Posts: 6
- Joined: Tue Jun 15, 2010 11:17 am
I need to generate the output as mentioned in the early post.
Initially I am doing couple of stages to get the dataset. After there is a table which contains the detail information about the ids and date. Now when ever I take Id and date from the dataset.
I will do lookup, join ...... The check must take the max date and other fields from the table where table date is less than equal to dataset date.
So that for each combinition of date and Id from dataset compare with the table and take the respective date and other details.
Initially I am doing couple of stages to get the dataset. After there is a table which contains the detail information about the ids and date. Now when ever I take Id and date from the dataset.
I will do lookup, join ...... The check must take the max date and other fields from the table where table date is less than equal to dataset date.
So that for each combinition of date and Id from dataset compare with the table and take the respective date and other details.