Hi All..
Can somebody tell me what is difference between hash file and data set and how it works in datastage..
thnks..
difference betn hash file-dataset
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
A hash file is a file for shaping a block of hash. I assume you mean hashed file, which is a mechanism for storing data that demonstrates extremely fast key-based access. These work only in server jobs. Data Sets store partitioned data in parallel job internal format, preserving the sorting and partitioning information. These work only in parallel jobs.
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.
In what aspect you are looking for?
As mentioned
hashed file - server jobs
Dataset - PX jobs.
Data are stored in Datastage internal formate in Dataset. Data are hashed based on the key specified in Hashed file.
As mentioned
hashed file - server jobs
Dataset - PX jobs.
Data are stored in Datastage internal formate in Dataset. Data are hashed based on the key specified in Hashed file.
Impossible doesn't mean 'it is not possible' actually means... 'NOBODY HAS DONE IT SO FAR'
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: