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
Oracle command "BETWEEN" in hash file
Moderators: chulett, rschirm, roy
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,
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,
Roy R.
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org
Time is money but when you don't have money time is all you can afford.
Search before posting:)
Join the DataStagers team effort at:
http://www.worldcommunitygrid.org