Reply To: Table compare reports identical when data is not identical.

#16137
Mark
Keymaster

Hi Justin,

Thanks for posting your question on the forum.

Please note that HVR Compare performs a data comparison, and not a table structure comparison. In heterogeneous environments it is not uncommon for table structures to differ although your example is an obvious case that you would expect to be reported, if table structure validation was part of the comparison.

Is it fair to assume that with your column width 172 on the source that there is data with more than 50 characters in the table? If this is the case, then in order to use HVR to move the data into PostgreSQL you must have instructed HVR to allow the truncation using TableProperties /IgnoreCoerceError or in recent versions TableProperties /CoerceErrorPolicy=<some value> and /CoerceErrorType=STRING_TRUNCATION. Since that would become part of your channel definition it is then also part of the basis for HVR to run the comparison. I.e. you told HVR that you would be OK with string truncation, so we will not flag data differences due to this (as long as, taking string truncation into consideration, data is identical otherwise). If there is no source data exceeding 50 characters then obviously the data validation would also report identical result because no string truncation would have taken place as part of the data movement.

So as a general note HVR compare looks for differences in the data, based on the data flow settings. Table definitions can be different, and you may have even performed transformation along the way. When HVR runs the compare we take all of this in consideration when we run the compare.

Hope this clarifies.

Mark.

Test drive
Contact us