DSXchange

I have seen a weired scenario. In test environment, it writes 8 rows and reads 8 rows from hash file. but in prod, it writes 8 but reads 9 (which we think is from previous run and file was not flushed properly).. Is that possible ?? just curious to know as the job was runn ing for years and it never occured before.
'Delete file before create' not checked
'Create file' checked
'Clear file bfore creating' checked

does this cause the issue ?? because it appears it does.

Thanks

No clue how to explain that one as long as you are certain you are reading and writing to the exact same hashed file. Worst case, manually delete the hashed file's directory and it will recreate it on the next run.

100% positive on that. like i said the same job has been running differently in 2 environments. same input data.

Write the output to a sequential file and find the difference / extra line.