Modify Stage(Defining new column with value assigned to it)

[parag.s.27]

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.

[ray.wurlod]

Modify stage can create new column but the value must be based on an input column using one of the functions available to this stage type.

[chulett]

So... use a Transformer?

[zapal]

The best way is to use the "Column Generator" stage.

[swades]

The best way is to use the "Column Generator" stage.

Did you tried

[zapal]

Yes. I can create a column with a hard-coded value in the Column Generator Stage.

[zapal]

Yes. I can create a column with a hard-coded value in the Column Generator Stage.

[parag.s.27]

So... use a Transformer?

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.

[ray.wurlod]

Please back this kind of assertion with empirical evidence. That is, create both kinds of job and take measurements. You may be surprised.

as a performance improvement task, we are replacing all those transformers those are performing operations that can be handled by another light weight stage.

[parag.s.27]

Please back this kind of assertion with empirical evidence. That is, create both kinds of job and take measurements. You may be surprised.

as a performance improvement task, we ...

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.