Also, the MD5 hash is a 16 byte value. Don't count the leading 0x. You can change the VARBINARY(40) to VARBINARY(16) and hashbytes returns the same value. So, there may be a truncation occurring going into your Informatica process. Sorry, I haven't touched Informatica in over 12 years.