DSXchange

Hi,
I have to do a join between a Flat file and an Hash file.
In the flat file I have the timestamp FLAT.FIELD_DATE.
In the hash file I have the timestamps HASH.START_DATE and HASH.END_DATE.

I have to develop the oracle's command FLAT_DATE BETWEEN START_DATE AND END_DATE (I mean HASH.START_DATE <= FLAT.FLIELD_DATE <= HASH.END_DATE).
Is it possible to do it?

tenks in advance

Mario

Hi,
you have 2 choices:
1. use a universe stage (search this forum)
2. load your source dates to a table and unload a join between that table and the one containing the actual date ranges implementing the between; the join should contain the source column date for simple hash join and the data you need from the table you performed the betwen on.

the first option is quite slow so for large volumes I'll go for option 2.

IHTH,