DESCRIPTION:
When running Integrity Manager test comparing 2 Strategy releases,the test result may show SQL mismatches for intermediate table column data type. In this example, the base Strategy release shows a data type BYTEINT and target Strategy release shows SMALLINT.
CAUSE:
This is an expected change as Strategy continues to improve the use of most appropriate data types used for different sources while creating intermediate table for SQL sources. As a result, customers may notice that intermediate table column data type may be different between base and target.
ACTION:
Upgrading to newer Strategy releases improves the usage of most appropriate data type while creating intermediate table for SQL sources.
Strategy reference numbers for this technical note are KB442143 and DE94307.
