If the source date, time, or timestamp values are out-of-range for a target column, Connect CDC updates the target column with NULL. For example, if you have a DB2 DATE datatype mapped to a SQL Server DATETIME datatype or SMALLDATETIME datatype; DB2 supports date values from the year 0001 to 9999 but the valid range of values for SQL Server is a subset of those values. If a DB2 date value is sent to a SQL Server target column and the value is out-of-range, Connect CDC silently substitutes a value of NULL.