Page 1 of 1
Lookup using </> in parallel jobs
Posted: Sun Jan 21, 2007 10:13 pm
by rejith.ry
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
Posted: Sun Jan 21, 2007 10:19 pm
by chulett
By "</>" do you mean "not equal"?
Posted: Sun Jan 21, 2007 10:34 pm
by rejith.ry
Hi
Posted: Sun Jan 21, 2007 10:40 pm
by rejith.ry
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.
Posted: Sun Jan 21, 2007 11:07 pm
by DSguru2B
Its a range lookup. Search on the keywords "range lookup". Do an exact search.
Posted: Sun Jan 21, 2007 11:42 pm
by rejith.ry
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?
Posted: Sun Jan 21, 2007 11:52 pm
by DSguru2B
Load your file into a temp table and write a sql query.
Posted: Mon Jan 22, 2007 4:53 pm
by kumar_s
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.
Posted: Mon Jan 22, 2007 6:00 pm
by DSguru2B
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.
Posted: Mon Jan 22, 2007 8:31 pm
by ray.wurlod
Range lookup is available in version 8.0.