Joiner condition

tsktsk123 · Post by **tsktsk123** » Wed May 14, 2008 11:23 am

hi,

I like to know if there is a way in which i can apply a condition in joiner stage. We need to pass the date from source and get corresponding value from lookup stage based on date between start and end date. Start and End date are the columns in lookup table(oracle stage).

Similarly like to know if we use any condition in lookup stage i.e give me value from the lookup where my source date falls between start and end date.

Appreciate any help on this.

regards,
senthil

Kirtikumar · Post by **Kirtikumar** » Thu May 15, 2008 1:04 am

If you search on 'range lookup' you will get many posts and options available to implement this.

bkumar103 · Post by **bkumar103** » Thu May 15, 2008 2:29 am

Datastage 7 does not provide the range lookup. The Range lookup is added as the new feature in DS 8.

tsktsk123 · Post by **tsktsk123** » Fri May 16, 2008 5:24 am

Thanks for the reply, is there any option in 7.5 using which we can implement this range lookup. One option is to use joiner/lookup and use a filter to apply the conditions. I like to know if there is any other option.