I am trying to set up data comparisons between DB2 and SQL Server. The millisecond precision is being dropped from DB2 timestamp values during the process. I've modified the Grid options to set the precision correctly, but that doesn't appear to be having any impact on the comparison. This is the error being caught by TDP - Green is DB2, Red is SQL Server:
I have personally verified the DB2 data matches the SQL Server values, but TDP is dropping the precision, causing the compares to throw false mismatches. Even worse, I have some tables using Timestamp as the primary key, and I am entirely unable to compare these tables - presumably due to this issue.