Implicit conversion from source type string[max=20]

sagar deshmukh · Post by **sagar deshmukh** » Mon Aug 23, 2010 3:38 am

Hi ,

Could you please help me in removing below warning from my job....
I am not able to understand ..why this warning is coming?

Code: Select all

Lkp_Validation,0: When binding input interface field "T_PROD_INFO" to field "T_PROD_INFO": Implicit conversion from source type "string[max=20]" to result type "string[max=4]": Possible truncation of variable length string

ArndW · Post by **ArndW** » Mon Aug 23, 2010 4:23 am

No problem in doing so, but you need to answer the following question first:

If your data contains "Hello There", what should the resultant string value be?

sagar deshmukh · Post by **sagar deshmukh** » Mon Aug 23, 2010 4:41 am

"Hello There"

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Aug 23, 2010 4:47 am

That is not going to happen if you move it to 4 chars string.

So you will need to expand the target to 20 chars length.

sagar deshmukh · Post by **sagar deshmukh** » Mon Aug 23, 2010 4:52 am

Hi

My target source everything is 20 bytes...That is why I am wondering why this is happeing?

ray.wurlod · Post by **ray.wurlod** » Mon Aug 23, 2010 5:05 am

Your target column is VarChar(4).

Check again.

priyadarshikunal · Post by **priyadarshikunal** » Mon Aug 23, 2010 5:29 am

If I understand it correctly, one of the links in Lkp_Validation lookup stage has it as varchar(4), check that.

Sandhya.Arumugam · Post by **Sandhya.Arumugam** » Wed Aug 24, 2011 9:52 am

I just fixed a similar warning and this solution worked for me.

I changed the column defintion as Varchar() and set Unicode in the extended property, in the job that threw the warning.

Check if this works for you.