Define New Column

[adityamohanty]

Hi Everybody,

Just Let me know apart from Modify Stage,Transformer Stage,Column Generator Stage, can we define any default new column in any stage in Data Stage.

Thanks In Advance
Aditya

[ray.wurlod]

Build stage, External Filter stage, just off the top of my head.

[adityamohanty]

Thnx for replying, I tried out but still it's not working.External Filter stage will create a new column for calculation. I want to pass a default value for that new column which is not possible in External Filter Stage.If you have any idea then please share with me.

[ray.wurlod]

Show us what you did in the External Filter stage's command. I would be fairly confident that one can, indeed, generate a different record schema on the output (and therefore can generate values that were not input).

[asorrell]

What is the problem in adding it via your transformer and putting in your default there as a hardcoded value? Or using a Column Generator?

I mean if you want esoteric ways to add columns you can use a row generator with a dummy key column and your new columns (defaults set in the metadata) and use a join stage to add it to your data stream.

We can throw complex, bad ways to add columns at you all day - why aren't you allowed to use the easy ways?

[adityamohanty]

Hay Andy,
I totally agreed what you are trying to say, but as far my question is concerned,it was asked me in one interview that "What are the four stage, we can define new column with a defaukt value". I had answered
1. Transformer
2.Modify
3.Column Generator
4.????

Thats why curiously wanted to know about fourth one.
Thanks for sharing your thoughts and Waiting for your answer as well

[greggknight]

Well maybe the interviewer wanted to know if you knew anything about Runtime Column Propagation for Parallel Jobs ??