Warnings in ODBC Connector Stage when Table Action = APPEND
Posted: Tue Feb 16, 2010 4:45 pm
Hi ,
In a jon I am try to populate Oracle table BY a source dataset with RCP Enabled.
In ODBC Connector Stage , Table Action = CREATE OR REPLACE then no warning is coming up.
bUT Table Action = APPEND then the mentioned warning is coming up :p-
TgtCDLTblODBC: The length of VARCHAR column STAT cannot be validated because the database column is WVARCHAR and character set conversion is involved. Inadequate column lengths can lead to data truncation or unexpected errors.
Please note source STAT Column is of Varchar type.
Kindly provide the inputs regarding it
In a jon I am try to populate Oracle table BY a source dataset with RCP Enabled.
In ODBC Connector Stage , Table Action = CREATE OR REPLACE then no warning is coming up.
bUT Table Action = APPEND then the mentioned warning is coming up :p-
TgtCDLTblODBC: The length of VARCHAR column STAT cannot be validated because the database column is WVARCHAR and character set conversion is involved. Inadequate column lengths can lead to data truncation or unexpected errors.
Please note source STAT Column is of Varchar type.
Kindly provide the inputs regarding it