Ray,
I am writing to the same hash file and reading from the same hash file by which i cant select the write cache option.
Thanks
Search found 2 matches
- Wed Oct 11, 2006 7:23 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hash File Tuning
- Replies: 5
- Views: 1223
- Wed Oct 11, 2006 3:18 pm
- Forum: IBM<sup>®</sup> Infosphere DataStage Server Edition
- Topic: Hash File Tuning
- Replies: 5
- Views: 1223
Hash File Tuning
I am trying to read 2 million row table (60 Columns of which 4 Columns are keys) into a hash file.its been taking around 2 hrs to load the data into the file with the default options that are provided with the Hash file.I tried to optimize the hash file using HFC.exe(Hash File Calculator tool),it sa...