DSXchange

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.

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.

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

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.