use of hash files
Moderators: chulett, rschirm, roy
use of hash files
hi,
i m new to datastage. i was going through the documentation but couldnt find what is the real use of hash files. The only thing i understand is that it uses hashing algorithm to feed the rows.
shivan
i m new to datastage. i was going through the documentation but couldnt find what is the real use of hash files. The only thing i understand is that it uses hashing algorithm to feed the rows.
shivan
-
- Premium Member
- Posts: 108
- Joined: Sat Feb 05, 2005 6:52 pm
- Location: US
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 232
- Joined: Sat May 07, 2005 2:49 pm
- Location: USA
-
- Premium Member
- Posts: 614
- Joined: Fri Feb 06, 2004 3:59 pm
Code: Select all
And to handle multivalue fields
what does the above statement mean ppalka? can explain me...
Thanks a bunch,
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A multi-valued field (or column) may contain a list, rather than an atomic value. Some databases support the concept, though sometimes not using this terminology. This is particularly so with a database that promises OLAP capability (such as Oracle 9i/10g and MS SQL Server Plato) and databases with a Pick heritage (such as UniVerse, UniData, D3 and so on).
The main "support" for multi-valued data in DataStage is the ability automatically to "explode", or "un-nest", the multiple values to expose the "nested table" in at least first normal form.
The main "support" for multi-valued data in DataStage is the ability automatically to "explode", or "un-nest", the multiple values to expose the "nested table" in at least first normal form.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.