Range Lookup in a parallel job

vnspn · Post by **vnspn** » Mon Aug 20, 2007 10:33 pm

Hi,

Is there any way to do a Range Lookup when the reference link is either from a Sequential File stage or from a Data Set stage?

In Server jobs, we have written the records to a Hashed File and then read it through a UniVerse stage to accomplish a Range Lookup. Is there some kind of means to achieve it in a parallel job?

Thanks.

ArndW · Post by **ArndW** » Mon Aug 20, 2007 10:36 pm

No, you cannot do a range lookup from a sequential or DataSet file in PX 7. You can use the same method you used in server jobs in PX - write to an SQL-capable source and use that in your lookup stage.

ray.wurlod · Post by **ray.wurlod** » Mon Aug 20, 2007 11:10 pm

Range lookups are supported in the Lookup stage in version 8.0.

vnspn · Post by **vnspn** » Tue Aug 21, 2007 7:04 am

ArndW,

Ok, you say to write it to a SQL-capable source and then do the Range Lookup. But there is no feature in parallel job to write to a Hashed File and then reading it using a stage like UniVerse stage.

So, is the only solution in parallel job is to write it to a database table and then read it from there?

Thanks for your inputs.