Page 1 of 1

Join stage warning for unicode set on Teradata column

Posted: Tue Sep 02, 2014 7:58 am
by Rajesh Jale
Hi,
I am using join stage to perform join operations on teradata connector and flat file. I have two columns (COL1, COL2) on teradata connector and COL1 is key column havning "EXTENDED" set as "Unicode".
COL1 Metadata is same on both Flat file and teradata connnector except "Unicode" set for teradata connector.

When I execute the job, i'm seeing following warning message when I have UNICODE set for COL1 on Teradata connector and no warning message when I remove it.

I need to read COL1 from Teradata connector with UNICODE also I want to avoid this warning. Can someone help me on this.

Warning : Join_stage: When checking operator: On input data set 1: When binding input interface field "COL1" to field "COL1": Implicit conversion from source type "ustring[max=30]" to result type "string[max=30]": Converting ustring to string using codepage ISO-8859-1.

Posted: Tue Sep 02, 2014 4:39 pm
by ray.wurlod
Make sure that the Unicode extension is either set on all links (input links and output link) or not set on all links.