Warning in the Oracle enterprise stage

kennyapril · Post by **kennyapril** » Thu Oct 20, 2011 9:53 am

I have fields in the source A, B, C which has lengths 1,5,20.
I gave a definedstring value in the environmental parameters for null values given as destr1,destr7 which gives values 'U' for destr1 and 'UNKNOWN' for destr7.

I used these definedstring values as NVL in the source query which gives me warning as the length should be 4 times of the destr length like the length for field A should be 4 but given 1 and 80 for field C but given 20.

Below is the warning

When checking operator: When binding output interface field "DEP" to field "DEP":Implicit conversion from source type "string[max=28]" to result type "string[5]": Possible truncation of variable length string.

It gave 28 as I gave destr7 which has length 7

please suggest if any changes are required

ray.wurlod · Post by **ray.wurlod** » Thu Oct 20, 2011 2:58 pm

That's just how the interaction with Oracle with NLS enabled works. Depending on version specify four times or three times the actual number of characters in the metadata. Or use a specific string_from_ustring specification to effect the transfer.

kennyapril · Post by **kennyapril** » Fri Oct 21, 2011 9:16 am

Thanks Ray.

please specify where do I use that function?

do we have any environmental parameter?

chulett · Post by **chulett** » Fri Oct 21, 2011 9:47 am

Modify stage.