Look up to Hash File

Optico · Post by **Optico** » Fri Sep 19, 2003 5:51 am

Hi.

As far as I know all lookups are done as '=' (equal to).

Use a constraint to only pass the data where your source file date is within the start/end date criteria.

B. Sorensen,
Optico IT ApS

WoMaWil · Post by **WoMaWil** » Fri Sep 19, 2003 5:52 am

No not via Hash,

but via you may use routine and/or other tricks, depending on how much it is.

Let us know more details.

Wolfgang Huerter
=====================
Cologne, Germany

kcbland · Post by **kcbland** » Fri Sep 19, 2003 6:37 am

I posted one technique with supporting functions to build hash lookups that work on equi-join or "=" but have nested all the rows required. Search for the following topic:

"Using hash files instead of UV tables for multirow"

Kenneth Bland

ray.wurlod · Post by **ray.wurlod** » Fri Sep 19, 2003 8:12 pm

For some reason there are two threads with this topic. I responded to the other one, with why the Hashed File is not appropriate for a BETWEEN join. Admin, can you merge these when populating the archive?

Ray Wurlod
Education and Consulting Services
ABN 57 092 448 518