difference betn hash file-dataset

helpmeout · Post by **helpmeout** » Thu Nov 02, 2006 3:18 pm

Hi All..
Can somebody tell me what is difference between hash file and data set and how it works in datastage..
thnks..

ray.wurlod · Post by **ray.wurlod** » Thu Nov 02, 2006 3:27 pm

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.

kumar_s · Post by **kumar_s** » Fri Nov 03, 2006 4:22 am

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.

trobinson · Post by **trobinson** » Fri Nov 03, 2006 6:38 am

To correct Ray, I believe he meant a frozen block of hash.

chulett · Post by **chulett** » Fri Nov 03, 2006 10:38 am

So says the voice of experience.

ray.wurlod · Post by **ray.wurlod** » Fri Nov 03, 2006 12:08 pm

If you have a coarse enough hash file... (ok, yeah, so it crumbles).