TrimLeadingTrailing() function usage in Transformer
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA
TrimLeadingTrailing() function usage in Transformer
We have job, in which we are using TrimLeadingTrailing() function twice in the derivation for about 200 fields.
Is there any limitation on usage of TrimLeadingTrailing() function in Parallel job Transformer stage.
Is there any limitation on usage of TrimLeadingTrailing() function in Parallel job Transformer stage.
Regards
VS
VS
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA
Job can able to compile upto certain number of columns with TrimLeadingTrailing function, after that its throwing the following warning.
1500-008: (S) COMPILER LIMIT EXCEEDED in APT_TransformOperatorImplV0S2_xyz_stage_xyzload_X_del_inst_upd::processInputRecord(int): Program too complicated to be compiled. Compilation ended. Reduce the complexity of the program and recompile, or lower the level of optimization and recompile.
1500-008: (S) COMPILER LIMIT EXCEEDED in APT_TransformOperatorImplV0S2_xyz_stage_xyzload_X_del_inst_upd::processInputRecord(int): Program too complicated to be compiled. Compilation ended. Reduce the complexity of the program and recompile, or lower the level of optimization and recompile.
Regards
VS
VS
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA
Open up your transform stage details and set the compiler flags, including the "-O0" option, in the "Compiler Flags" line f the "Build" tab.
I don't think that there is much of a penalty if you remove the optimization at the project level (through the Administrator tool), since much of transform processing is simple if-then-else that cannot be optimized much.
I don't think that there is much of a penalty if you remove the optimization at the project level (through the Administrator tool), since much of transform processing is simple if-then-else that cannot be optimized much.
-
- Participant
- Posts: 123
- Joined: Wed May 18, 2005 7:41 am
- Location: USA