Input string too long error while compliing job

dalvigirish · Post by **dalvigirish** » Mon Aug 07, 2006 3:47 am

I am getting error below while compiling datastage job. I am using very long expression in transformer, I have no other option than using it. Is there any solution for this issue.

Compiling: Source = 'RT_BP48/JOB.1381947501.DT.1408851130.TRANS1', Object = 'RT_BP48.O/JOB.1381947501.DT.1408851130.TRANS1'
*************************************************************************************************************************************************Input string too long, limit 8192
(CUS_Load_Address_Dtl.TRN_Apply_Business_Logic)

Thanks in Adv.
Girish Dalvi

kumar_s · Post by **kumar_s** » Mon Aug 07, 2006 4:37 am

may be you can share, Under what curcumstance you are using the long expression, so that you may get a better approach.

loveojha2 · Post by **loveojha2** » Mon Aug 07, 2006 5:11 am

I have no other option than using it

I guess you ar hitting the limit allowed for the max number of characters permissible.
Can't you just replace it with a function?

dalvigirish · Post by **dalvigirish** » Mon Aug 07, 2006 6:39 am

The data on which I am working is not cleansed data. I am cleaning and applying transformation rules in transformar. e.g my address detail tables, 'C/O' string is inputed as 'C / O','C.O','C/ O','C/ '. I am finding all the occurances of these, replacing it with stanard format and based on these, i am updating other columns of o/p tables. Due to these reasons, if-else string is becoming very long.
What is the max length of rule can be written in transformer??

Girish Dalvi

balajisr · Post by **balajisr** » Mon Aug 07, 2006 6:42 am

dalvigirish wrote:The data on which I am working is not cleansed data. I am cleaning and applying transformation rules in transformar. e.g my address detail tables, 'C/O' string is inputed as 'C / O','C.O','C/ O','C/ '. I am finding all the occurances of these, replacing it with stanard format and based on these, i am updating other columns of o/p tables. Due to these reasons, if-else string is becoming very long.
What is the max length of rule can be written in transformer??

Girish Dalvi

limit is specified in your error message. It is 8192.

kcbland · Post by **kcbland** » Mon Aug 07, 2006 6:44 am

use functions

rameshrr3 · Post by **rameshrr3** » Mon Aug 07, 2006 8:43 am

Can you use 2 or 3 transformers in cascade? That might reduce the length of your derivation. USe some stage variables to store intermediate results or flag status. This is not very elegant , but if it is a quick fix, then you know what actually causing the error. ALternatively , you can create a function/routine that uses case statements.

Are you using transformer stage in server jobs or basic transformer in patrallel job?