Modify Stage(Defining new column with value assigned to it)
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 221
- Joined: Fri Feb 17, 2006 3:38 am
- Location: India
- Contact:
Modify Stage(Defining new column with value assigned to it)
Can we create a new column in modify stage output link with some value assigned to that field.
I want to create a column named 'TARGET_TABLE_NAME' with the value hard-coded as 'POLICY'. Is that feasible?
And for this what function is needed to be mentioned as Specification?
Please give me a suggestion on this regard.
Thanks in Advance.
I want to create a column named 'TARGET_TABLE_NAME' with the value hard-coded as 'POLICY'. Is that feasible?
And for this what function is needed to be mentioned as Specification?
Please give me a suggestion on this regard.
Thanks in Advance.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 221
- Joined: Fri Feb 17, 2006 3:38 am
- Location: India
- Contact:
Actually we were earlier using a transformer, but as a performance improvement task, we are replacing all those transformers those are performing operations that can be handled by another light weight stage. Just to add a column in the incoming stream of data, a transformer usage is too costly.chulett wrote:So... use a Transformer?
Thanks & Regards
Parag Saundattikar
Certified for Infosphere DataStage v8.0
Parag Saundattikar
Certified for Infosphere DataStage v8.0
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Please back this kind of assertion with empirical evidence. That is, create both kinds of job and take measurements. You may be surprised.
parag.s.27 wrote:as a performance improvement task, we are replacing all those transformers those are performing operations that can be handled by another light weight stage.
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: 221
- Joined: Fri Feb 17, 2006 3:38 am
- Location: India
- Contact:
We can check for number of processes created by each stage used in a particular IIS job on the AIX box. If you check for processes created by Modify stage and Transformer stage on the OS, then you'll find that transformer stage creates more number of processes. It may not mean that its performance will necessarily be less as compared to modify stage. But to get these comparison figures, I have to create the same job using Modify stage, and hence I did ask about how to create a default column with default value in Modify stage. Performance wise if it will be same as transformer, then we'll use the transformer only.ray.wurlod wrote:Please back this kind of assertion with empirical evidence. That is, create both kinds of job and take measurements. You may be surprised.parag.s.27 wrote:as a performance improvement task, we ...
Thanks & Regards
Parag Saundattikar
Certified for Infosphere DataStage v8.0
Parag Saundattikar
Certified for Infosphere DataStage v8.0