DSXchange

Hi all,

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




Thanks in advance,
Raj.

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.