Possible truncation of variable length ustring

[gowrishankar_h]

Hi,

I want to convert varchar(11) column to char(11).So i used modify stage to convert the datatype.I simply changed the datatype in output metadata and set the specification as NOWARN but still iam getting waring in output as below.


On input data set 1: When binding input interface field "WCC_GS_CTS_PARTY_ID" to field "WCC_GS_CTS_PARTY_ID": Implicit conversion from source type "ustring[variable_max=11]" to result type "string[11]": Possible truncation of variable length ustring when converting to string using codepage UTF-8.

How to avoid this warning?.

[crystal_pup]

One way is to not to define the length of the target datatype.

[gowrishankar_h]

Target datatype means both the join input or join stage output?


Note:when i use Transformer instead of modify stage iam not getting this warning...but i hope using modify stage in this scenirio is good pracitce.

[ray.wurlod]

Did you mention the cast (change of data type) in the Modify stage specification?

Code: Select all

newcol:ustring[11]=inputcol

(Use ustring if Unicode, UTF-8, etc., are in play; use string otherwise.)

[gowrishankar_h]

Yes but still i am getting the warning..i replaced the modify stage with transformer stage now it work fine ...