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
doing lkup in 7.1
Moderators: chulett, rschirm, roy
-
- Charter Member
- Posts: 822
- Joined: Sat Sep 17, 2005 5:25 pm
- Location: USA
thanks for the help ,,, but if i use the method u are suggesting , are there chances or cartition productus1aslam1us 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
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.