Warning: A mapping results in a warning in DDW because of the following possible reasons:
The source data type may not be compatible with the target data type. This incompatibility may cause a conversion failure at Runtime.
The maximum string length of the source data type exceeds the string length of the target data type. This mapping may cause a conversion failure at Runtime.
The value range of the source data type exceeds the value range of the target data type or the scale of the source data type exceeds the scale of the target data type. Data loss may occur at Runtime.
The precision of the source data type exceeds the precision of the target data type. Data loss may occur at Runtime.
Converting a floating-point number in the source data type to a nonfloating-point number in the target data type may cause data loss at Runtime.
The encoded value of the source data type may not be compatible with the encoded value of the target data type. This incompatibility may cause a conversion failure at Runtime.
For mappings from Enterprise Database Server to SQL Server
The source data type is External Large Object or TimeStamp, which is not supported in a bulk data transformation.
For mappings from RDMS to SQL Server
The source data type is TimeStamp, which is not supported in a bulk data transformation.
For mappings from Enterprise Database Server to Oracle Database
The source data type is External Large Object or NCLOB, which is not supported in a bulk data transformation.
May Have Warning: A mapping may result in a warning in DDW depending on parameters, such as Precision, Value, Scale Factor, and Length of the string of the source data types and the target data types.