doing lkup in 7.1

DS1 · Post by **DS1** » Fri May 12, 2006 12:56 pm

hello,,

I want to do a lookup on teradata table with data from dataset with the conditions --

when dataset.id = teraTable.id and dataset.date < TeraTable.date

The first condition can be fulfilled using the key option ,,,
but about the second condition of inequality .. how do i deal with it ,,
is there a way i can pass the date into the tera stage to be able to query such that only the appropriate data comes ????

can anyone please help me out with this

Thanks

us1aslam1us · Post by **us1aslam1us** » Fri May 12, 2006 2:28 pm

why dont you do the lookup on id and use a transformer or modify stage for checking date condition.But i am not sure whether you will be able to do something in query.

Thanks
Sam

DS1 · Post by **DS1** » Fri May 12, 2006 2:52 pm

us1aslam1us wrote:why dont you do the lookup on id and use a transformer or modify stage for checking date condition.But i am not sure whether you will be able to do something in query.

Thanks
Sam

thanks for the help ,,, but if i use the method u are suggesting , are there chances or cartition product

ray.wurlod · Post by **ray.wurlod** » Fri May 12, 2006 3:16 pm

The Lookup stage performs only equi-joins. You are probably better off performing the join in the database prior to receiving the result rows into DataStage. Of course, I am assuming that your other source data are also in Teradata; if they're not, you could readily load them into a temporary table and join that to the reference table.