• 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.