Lots of warning because of transformation

ray.wurlod · Post by **ray.wurlod** » Tue Feb 19, 2008 1:47 am

Do some investigation. Create a throw-away job to read the source data and report the actual length of this field (using the Len() function). Just out of curiosity, also report the number of bytes (using the ByteLen() function). Send the result into a delimited text file.
Process a few rows, in particular some of the ones that threw the error, and let us know what you see.
Then enhance the throw-away job with part of the expression (say the Trim() function initially) and report that and its length. Then the substring.

laxman.ds · Post by **laxman.ds** » Tue Feb 19, 2008 2:36 am

I checked the problem feild length it is 16
But Iam not able to use bytelen function it is not available
Iam using Servere jobs.
Please advice

ray.wurlod · Post by **ray.wurlod** » Tue Feb 19, 2008 2:39 am

ByteLen() is available. It may stay red (because it is not in DSParams file) but it will compile and it will run.

laxman.ds · Post by **laxman.ds** » Tue Feb 19, 2008 3:49 am

Thanks for your support ..
I rectified the problem ..
The issue was regarding NLS mapping at oracle...That was Arabic data ..was not able to insert ...I corrected the NLS setting ..
Now it is runnign fine

asitagrawal · Post by **asitagrawal** » Tue Feb 19, 2008 4:36 am

Time to mark the topic as Resolved please