DSXchange

I am sorry, the logic has to be changed a bit.i will try to give in some time.

I have a solution but it will in terms of server job. Create a dummy hash file somewhere. In this job have the hash file as lookup as well as update stage. The hash file will have id as key and a column like flag. Logic : Update the value of flag with "Y" if it 20 Or 24 and "N" i...

Ur is a city of ancient Babylon. The second person personal pronoun is "you", not "u". We expect professionalism in communication here. Since professionalism is expected. A professional will give solutions to problems rather than looking for loopholes in the questions. I believe...

When extractying data from Sybase database to a flat file, the count was wrong.

I had a similar problem where my hash file had 3 keys in which the key cols were not continuous from the start. So if a transformer is not used when data is transfomed to hash file then it would give problem if the keys are not continuous from the start. So try giving the key column as the first col...

DSLinkRowCount sometimes gives wrong values. I am not sure why this happens. So just check before using it.

If still the problem persists. Just trim the key column in the hash file. Also while joining with hash file from source file have a trim of the source field.

When it is 2405269 in table how will you find 2405265 in hash file. 2405269 <> 24052695. Check if the lookup has 2405269.

Please elaborate your question.
One of the option from my understanding of your question is to use Update/Insert option in the Oracle stage.

Could you check like you have given the same path in the Input & output tab of Hash file. If you have given a path in input & some other path in output, it may take from the old hash file.