DSXchange

Other than "Concentrate your investigation on the transformer stage..." it will be hard for us to recommend a course of action.

It may also sound silly, but you might want to drag a new transformer stage onto the canvas and retype the logic into it, then delete the old transformer stage.

Do other jobs with transformer stages fail to compile or is it just this one?
(you may have to force compile another job to test it).


Are there any custom routines being used in that transformer stage?

Thanks for your reply Paul.

I will try replacing transformer stage and rewriting the logic.

I have been trying force compile always. Other jobs are compiling fine with no issues.

There is not any custom routine in the transformer.

Replaced transformer and defined derivations again , still no luck

Check below link and confirm

Error compiling Infosphere DataStage jobs with transformer stage

http://www-01.ibm.com/support/docview.w ... wg21414560

Removed constraint condition from Transformer and used filter stage before that instead.

working fine now.

thanks all

Did you move or Removed the derivation of if-then-else logic that was coded in Transformer?