dummy column

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
pavan_test
Premium Member
Premium Member
Posts: 263
Joined: Fri Sep 23, 2005 6:49 am

dummy column

Post by pavan_test »

is it possible to create a dummy column (not coming from input) in datastage and assign some value to it say 'z'

what etl stage should I use to create a dummy column and assign value to it.

Thanks
Mark
pavan_test
Premium Member
Premium Member
Posts: 263
Joined: Fri Sep 23, 2005 6:49 am

Re: dummy column

Post by pavan_test »

can I create column "dummy" using sequential stage and assign value as 'z' (or something else)

In sequential stage i was able to create a column but I could not assign value to that column.

thanks
Mark
anbu
Premium Member
Premium Member
Posts: 596
Joined: Sat Feb 18, 2006 2:25 am
Location: india

Post by anbu »

You can do it in transformer
You are the creator of your destiny - Swami Vivekananda
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

My preference would be a Column Generator 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.
behrouz
Participant
Posts: 41
Joined: Tue Oct 28, 2008 4:13 am

dummy

Post by behrouz »

ray.wurlod wrote:My preference would be a Column Generator stage. ...
You can create your dummy column in Generator stage and give the value
and run it only for 1 records

Arash.
Post Reply