how to get server transformer stage in parallel jobs?
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 81
- Joined: Thu Nov 30, 2006 7:46 am
- Location: india
how to get server transformer stage in parallel jobs?
i have few routines in datastage server jobs, i have one requirenment in parallel jobs to use those routines? how to get the server tansformer stage in paralle jobs?
Regards
Malli
Regards
Malli
MALLI
Open Parallel Job -->expand Processing Palette --> right click & choose Customization --> Customize..--> under repository item & under Stage types expand Parallel and highlight BASIC Tranformer and move it to right side window (Current Palatte groups and shortcut items:).
Quality is never an accident; it is always the result of high intention, sincere effort, intelligent direction and skillful execution; it represents the wise choice of many alternatives.
By William A.Foster
By William A.Foster
-
- Participant
- Posts: 81
- Joined: Thu Nov 30, 2006 7:46 am
- Location: india
-
- Participant
- Posts: 81
- Joined: Thu Nov 30, 2006 7:46 am
- Location: india
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Not true. The BASIC Transformer stage can run in parallel, though every node on which it executes must be on the (a) machine where the DataStage server engine is installed.
You can also include server shared containers in parallel jobs, subject to certain restrictions that are documented in Chapter 2 of the Parallel Job Developer's Guide - this is another way to incorporate server Transformer stage.
The difference is that a BASIC Transformer does not perform lookups, while a server Transformer can.
In any event, try not to do any of these things. Figure out how to do what you want to do using native parallel stage functionality as much as possible.
You can also include server shared containers in parallel jobs, subject to certain restrictions that are documented in Chapter 2 of the Parallel Job Developer's Guide - this is another way to incorporate server Transformer stage.
The difference is that a BASIC Transformer does not perform lookups, while a server Transformer can.
In any event, try not to do any of these things. Figure out how to do what you want to do using native parallel stage functionality as much as possible.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Since I pointed out the difference between BASIC Transformer and server Transformer in my post, how can you claim that I said they're the same?!!
Premium membership is inexpensive, at less than 30c (Rs12) per day, and helps to fund the hosting and bandwidth costs incurred by DSXchange.com.
Premium membership is inexpensive, at less than 30c (Rs12) per day, and helps to fund the hosting and bandwidth costs incurred by DSXchange.com.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
The question was "is it possible to use server transformer in parallel job?"
DSGuru told that it can be used and it will be executed in sequential mode.
Then you started with "Not true. BASIC transformer can run in parallel" So i ended up asking whether BASIC transformer is nothing but Server transformer?
Anyways, hope the poster is clarified.
DSGuru told that it can be used and it will be executed in sequential mode.
Then you started with "Not true. BASIC transformer can run in parallel" So i ended up asking whether BASIC transformer is nothing but Server transformer?
Anyways, hope the poster is clarified.
Kandy
_________________
Try and Try again…You will succeed atlast!!
_________________
Try and Try again…You will succeed atlast!!
-
- Participant
- Posts: 597
- Joined: Fri Apr 29, 2005 6:19 am
- Location: Singapore
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Premium Member
- Posts: 99
- Joined: Mon Sep 03, 2007 7:49 am
- Location: Stockholm, Sweden
I am not sure that we did something really wrong, but we had a consultant which implemented transformations in parrallel jobs using a BASIC tarnsformer and we had problems with all those jobs every 3-5 run, where the job would fail due to broken pipes. I spent 4-6 month recoding every job into parallel transformers and we got runtime stability....
-------------------------------------
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles
http://it.toolbox.com/blogs/bi-aj
my blog on delivering business intelligence using agile principles
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact: