Hash File Clear hash Option

[sumeet]

Hi ,

In Server Jobs if we dont clear Hash file. what happens to it during the next run to the file.

Is the Data in Hash file from previous run purged or it keeps on appending the data to previous file.

Thanks
Sumeet

[DeepakCorning]

Is the Data in Hash file from previous run purged or it keeps on appending the data to previous file. --

If you do not check delete of clear in th ehashed file property then It purges (appends) the data if the key columns for the next run are unique. If not then it will update the existing data.

[kduke]

It appends or overwrites based on the key.

[kduke]

It does not purge anything. It overwrites the whole record, every column or inserts a new record.

[DeepakCorning]

Oops I think i used purged word...Thanks Kduke for correcting..