DSXchange

Reducing the Array size and records counts worked for and my job is running without below two parameters as well.

APT_TERA_64K_BUFFERS=1
APT_TERA_64K_BUFFERSIZE=64000

Thanks and regards,
Kunal Shah

Ray, Thanks for reply, But in Table is created as Latin and in NLs is already to ISO-8859-1. But still facing the problem.

Hey buddy, Just once contact to your ADMIN team, as I can see the error as "DS_001,0: /bin/echo: write error: Broken pipe", I have faced same issue, and on contacting the DS-ADMIN (Server Team) our issue used to get resolved. So juat an suggestion, to contact the ADMIN team, mentioning the...

Guys, Thanks for Help, the issue is resolved, it was the problem due to ^M character in Source File.

Thank you all for your help.

Thanks Kalyan, I did that, but still not able to get the desired result, and getting the Zeros in output. but the same functionality is working fine for other job. So appreciate the help in this matter...

I want to convert my Varchar(9) field to Numeric(9), but I am not able to do that in TFM stage with StringToDecimal Function. So plz help me in this...
Regards,
Kunal Shah