Multiple keys using hash file

s_rajeshin · Post by **s_rajeshin** » Mon May 28, 2007 11:01 pm

Hi all,

Using multiple keys with hash files leads to exclusion of duplicates.Is there any way to avoid this.

Thanks in advance,
Raj.

ray.wurlod · Post by **ray.wurlod** » Mon May 28, 2007 11:12 pm

Welcome aboard. :D

It has nothing to do with multiple key columns. Even with a single key column a hashed file can not have a duplicate. This is how hashed files work. Any write with an existing key value (single or multiple column) is a destructive overwrite.

Some folks leverage this to make the hashed file stage a "remove duplicates" stage.