Erros in using Transformer Stage

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
yaminids
Premium Member
Premium Member
Posts: 387
Joined: Mon Oct 18, 2004 1:04 pm

Erros in using Transformer Stage

Post by yaminids »

Hello there,

If am using Transformer Stage in a Prallel job, I am getting errors like 'Operator error'. In the same job, if I use another stage, the job is compiling successfully.
My question is 'Is there any problem with the Transformer Stage.' Does this problem relate to the C++ Compiler.
Can anyone clear my doubts please.

Thanks in advance.
-Yamini
Mat01
Premium Member
Premium Member
Posts: 50
Joined: Wed Jun 02, 2004 11:12 am
Location: Montreal, Canada

Post by Mat01 »

Hi,

Try the test I suggested on this post:
viewtopic.php?t=89710

If you encounter compilation problems with an "empty transformer" (as in a transformer doing nothing), it is a good indicator that your compiler may be the issue.

Regards,

Mat
gh_amitava
Participant
Posts: 75
Joined: Tue May 13, 2003 4:14 am
Location: California
Contact:

Post by gh_amitava »

Hi yaminids,

Check your transformer. If it is a basic transformer then replace it by a PX transformer. Basic transformer gives lot of problem when we use it in PX job.

Regards
Amitava
yaminids
Premium Member
Premium Member
Posts: 387
Joined: Mon Oct 18, 2004 1:04 pm

Loading columns in the target database

Post by yaminids »

Hello Amitava,

Thank you for your reply. How can I know what transfromer(Basic or Parallel) I have. Basically, there is only one Transformer under 'Processing' section.

-Yamini
gh_amitava
Participant
Posts: 75
Joined: Tue May 13, 2003 4:14 am
Location: California
Contact:

Post by gh_amitava »

Yamini,

The transformer which is under "Processing" of Designer is the Basic transformer. Don't use this one. But the transformer which is under Stage Types -> All -> Processing in the Repository of Designer is a PX one. Use this.

Regards
Amitava
yaminids
Premium Member
Premium Member
Posts: 387
Joined: Mon Oct 18, 2004 1:04 pm

Loading columns in the target database

Post by yaminids »

Hello Amitava,

Thank you once again for your help. Can you explain to me how to use the transformer present in the repository of DataStage Manager in DataStage Designer.

I appreciate your time.
-Yamini
gh_amitava
Participant
Posts: 75
Joined: Tue May 13, 2003 4:14 am
Location: California
Contact:

Post by gh_amitava »

Hi,

Just go to the Designer and add the repository by clicking right.

Regards
Amitava
yaminids
Premium Member
Premium Member
Posts: 387
Joined: Mon Oct 18, 2004 1:04 pm

Loading columns in the target database

Post by yaminids »

Hi Amitava,

Thank you very much for your help.
-Yamini
Post Reply