I am hoping someone has some crossover experience here. I am attempting to utilize the Hashbytes function within SQL to match a value that is being generated utilizing the MD5 function from Informatica.
Has anyone ever been dove into this issue? My first assumption is that since the systems are different, the actual calculation of the checksum might have minute differences. It also could be how I am attempting to concatenate the values prior to using the hashbytes MD5 function.
I am at a loss, and am beginning to think it won't ever be possible to match these values (as many have said online) Any help would be greatly appreciated.
