Hash file

datasis · Post by **datasis** » Mon Nov 30, 2009 4:59 am

What is difference between Static hash file and dynamic hashfile

vinsashi · Post by **vinsashi** » Mon Nov 30, 2009 5:02 am

if your data is size fixed(known) then you will go for static hash file.if your data size is unknown then you will go for dynamic hashfile.but in data stage default type 30 dynamic file will create.

Thanks
vin...

datasis · Post by **datasis** » Mon Nov 30, 2009 5:22 am

How do we diff static and dynamic hash file,how do we create , hot to identify the idfference

vinsashi · Post by **vinsashi** » Mon Nov 30, 2009 5:42 am

Hi,
in the hashed file stage you should enable create file option then here you will get options type2 to type18 and type25,dynamic type30.
if we create static has file two files wil create where you given path(one is d_filename,filename).if you create dynamic hash file one folder with hash filename,and another one d_finename two will create where u given path(to store hashfile).if you mention default uesraccount then it will store under project folder.

Thanks
vin...

datasis · Post by **datasis** » Mon Nov 30, 2009 5:44 am

How do we diff static and dynamic hash file,how do we create , hot to identify the idfference

vinsashi · Post by **vinsashi** » Mon Nov 30, 2009 5:48 am

Hi,
in the hashed file stage you should enable create file option then here you will get options type2 to type18 and type25,dynamic type30.
if we create static has file two files wil create where you given path(one is d_filename,filename).if you create dynamic hash file one folder with hash filename,and another one d_finename two will create where u given path(to store hashfile).if you mention default uesraccount then it will store under project folder.

Thanks
vin...

ray.wurlod · Post by **ray.wurlod** » Mon Nov 30, 2009 3:48 pm

A hash file is used for shaping a block of hash.

A DataStage hashed file, if created as Type 30, is "dynamic" (automatic table space management) whereas, if created as Types 2-18, is "static" (manual table space management).

Types 1, 19, 25, 27 and 41 are not hashed files at all.