Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.
Moderators: chulett , rschirm , roy
rejith.ry
Participant
Posts: 21 Joined: Thu Jun 08, 2006 3:37 am
Post
by rejith.ry » Sun Jan 21, 2007 10:13 pm
Hi,
I want to extract some records from the reference data based on(</>) criteria. ie. get a column from reference link which is <= the input column. If it is an "=" criteria, we can directly map the input and reference columns. How to put the </> in lookup stage. Or is there any other stage supporting this?
Rejith
Rejith R
chulett
Charter Member
Posts: 43085 Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO
Post
by chulett » Sun Jan 21, 2007 10:19 pm
By "</>" do you mean "not equal"?
-craig
"You can never have too many knives" -- Logan Nine Fingers
rejith.ry
Participant
Posts: 21 Joined: Thu Jun 08, 2006 3:37 am
Post
by rejith.ry » Sun Jan 21, 2007 10:34 pm
Hi
Last edited by
rejith.ry on Sun Jan 21, 2007 10:51 pm, edited 1 time in total.
Rejith R
rejith.ry
Participant
Posts: 21 Joined: Thu Jun 08, 2006 3:37 am
Post
by rejith.ry » Sun Jan 21, 2007 10:40 pm
chulett wrote: By "</>" do you mean "not equal"?
No .
It is less than ...
I want to use less than/Greater than/ less than or equal to in lookup stage.
Rejith R
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Sun Jan 21, 2007 11:07 pm
Its a range lookup. Search on the keywords "range lookup". Do an exact search.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
rejith.ry
Participant
Posts: 21 Joined: Thu Jun 08, 2006 3:37 am
Post
by rejith.ry » Sun Jan 21, 2007 11:42 pm
DSguru2B wrote: Its a range lookup. Search on the keywords "range lookup". Do an exact search. ...
Is range lookup available in PX 7.5.1?
If not what to do?
Rejith R
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Sun Jan 21, 2007 11:52 pm
Load your file into a temp table and write a sql query.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
kumar_s
Charter Member
Posts: 5245 Joined: Thu Jun 16, 2005 11:00 pm
Post
by kumar_s » Mon Jan 22, 2007 4:53 pm
No Range lookup available in the version as such. But you can make some work around. If the sources are database, you can do the lookup in Database level. Else you can approach as DSGuru2B suggested, by loading into table. There are several other ways as well.
But you need to explain you job design and logic on which you do your lookup.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
DSguru2B
Charter Member
Posts: 6854 Joined: Wed Feb 09, 2005 3:44 pm
Location: Houston, TX
Post
by DSguru2B » Mon Jan 22, 2007 6:00 pm
If you load your flat file into a temp table then you can get everything done in a single query. i.e, a single database stage.
Creativity is allowing yourself to make mistakes. Art is knowing which ones to keep.
ray.wurlod
Participant
Posts: 54607 Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:
Post
by ray.wurlod » Mon Jan 22, 2007 8:31 pm
Range lookup is available in version 8.0.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.