Lookup using </> in parallel jobs

rejith.ry · 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

chulett · Post by **chulett** » Sun Jan 21, 2007 10:19 pm

By "</>" do you mean "not equal"?

rejith.ry · Post by **rejith.ry** » Sun Jan 21, 2007 10:34 pm

rejith.ry · 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.

DSguru2B · Post by **DSguru2B** » Sun Jan 21, 2007 11:07 pm

Its a range lookup. Search on the keywords "range lookup". Do an exact search.

rejith.ry · 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?

DSguru2B · Post by **DSguru2B** » Sun Jan 21, 2007 11:52 pm

Load your file into a temp table and write a sql query.

kumar_s · 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.

DSguru2B · 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.

ray.wurlod · Post by **ray.wurlod** » Mon Jan 22, 2007 8:31 pm

Range lookup is available in version 8.0.