datastage

sureshchandra · Post by **sureshchandra** » Wed Jun 06, 2007 6:19 am

How to use dummy key in a hash file?

DSguru2B · Post by **DSguru2B** » Wed Jun 06, 2007 7:37 am

Welcome Aboard

You have posted in the wrong forum. This forum is for parallel job specific question.
You hardcode the value for the key while building the hashed file to say 'X'. When you read the hashed file, hardcode the value 'X' for the key and for each incoming record, the hashed file will be read.
But this way only one record can be stored in the hashed file.

chulett · Post by **chulett** » Wed Jun 06, 2007 7:40 am

One record per 'hard coded' value that is.

georgesebastian · Post by **georgesebastian** » Tue Jun 12, 2007 9:31 pm

DSguru2B wrote:Welcome Aboard
You have posted in the wrong forum. This forum is for parallel job specific question.
You hardcode the value for the key while building the hashed file to say 'X'. When you read the hashed file, hardcode the value 'X' for the key and for each incoming record, the hashed file will be read.
But this way only one record can be stored in the hashed file.

Hi DsGuru,

One record per hashed file and for each incoming record the hashed file will be read.thats all fine...
But what will be the use of this Dummy key?Do the source needs to lookup the hashed file through the Dummy key?

Thanks
George Sebastian

ray.wurlod · Post by **ray.wurlod** » Tue Jun 12, 2007 10:09 pm

No more answers till this is in the server forum.