Code: Select all
odbc_lkp: Error when checking operator: When binding output interface field "DATE_CALLED" to field "DATE_CALLED": No default type conversion from type "ustring[max=10]" to type "date".
Code: Select all
Seq File to Join stage to Transformer to ODBC stage.
another ODBC stage coming to Join stage.
1. Run with NVarchar(10) in target odbc, lookup odbc and transformer
2. Run with date(10) in target odbc, lookup odbc and transformer
3. Run with varchar(10) in target odbc, lookup odbc and transformer
First, why is it getting converted to NVarchar during import and what should I use ?
Appreciate any help.