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
Input string too long error while compliing job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 5
- Joined: Thu Dec 29, 2005 1:33 am
-
- Participant
- Posts: 5
- Joined: Thu Dec 29, 2005 1:33 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
What is the max length of rule can be written in transformer??
Girish Dalvi
limit is specified in your error message. It is 8192.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
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?
Are you using transformer stage in server jobs or basic transformer in patrallel job?