Good Morning all...!!!
Am getting the following error:
My Job flow Proceess is as follows:LookUp: When checking operator: On output data set 0: When binding output schema variable "outputData": When binding output interface field "COLUMN_NM_1" to field "COLUMN_NM_1": Implicit conversion from source type "string[5]" to result type "string[2]": Source string will be truncated.
LookUp: When checking operator: On output data set 0: When binding output schema variable "outputData": When binding output interface field "COLUMN_NM_2" to field "Reject: When checking operator: When validating export schema: At field "COLUMN_NM_2": Exporting nullable field without null handling properties": Implicit conversion from source type "string[5]" to result type "string[2]": Source string will be truncated.
Reject: When checking operator: When validating export schema: At field "COLUMN_NM_3": Exporting nullable field without null handling properties
Reject: When checking operator: When validating export schema: At field "COLUMN_NM_4": Exporting nullable field without null handling properties
Code: Select all
Db2_API_1 Db2API_2 Db2API_3
\ | /
\ | /
DB2UDB_API ----Transformer-----Lookup------Transformer-------DataSet
|
|
Reject
lookup table the COLUMN_NM_1 = Length 4
DB2 Source table COLUMN_NM_1 = Length 5
lookup table the COLUMN_NM_2 = Length 2
DB2 Source table COLUMN_NM_2 = Length 5
Tried for COLUMN_NM_1[4,5] and COLUMN_NM_1[2,5] but still get this error.
And for COLUMN_NM_3 and COLUMN_NM_4
There is no nullable data so tried the IF ISNULL(column) then ' ' else Column
but still keep getting these errors.
Would appreciate any guidence.