I have created a job that creates 10 hash files. Each hash file will be incorporated into a distributed hash file. The average number of rows in each hash file is 6 million. The hash file has 4 columns that make up the key, the constraint in the job is based on the value in only one of the hash file key columns.
When I create the distributributed hash file, I use the INTERNAL option and use @ID e.g. INTERNAL "IF @ID >= 4000000 AND @ID < 8000000 then 1 ELSE 2"
Seeing that @ID is the whole key in the hash file, I'm not sure this will work when trying to do a lookup against the distributed hash file because the job that creates the hash files uses only a part of the hash file key.
![Confused :?](./images/smilies/icon_confused.gif)
How does the SYSTEM option work when creating a distributed hash file? Will this perhaps solve my problem?
Any suggestions on how to create a distributed hash file when the hash file has more than one column as the key?