How to achieve the output from DS8.1

[jsuryanathan]

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

[vinothkumar]

Can you please give your requirement.

[chulett]

In other words, spell out your requirements in words for us, just like someone must have spelled it out for you.

[jsuryanathan]

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.

[jsuryanathan]

Any one help on this please

[madhukar]

what i understand from you requirenent is that you need to do a range lookup which DS8 provides...