Page 1 of 1

dummy column

Posted: Thu Jul 01, 2010 1:52 pm
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

Re: dummy column

Posted: Thu Jul 01, 2010 2:04 pm
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

Posted: Thu Jul 01, 2010 2:20 pm
by anbu
You can do it in transformer

Posted: Thu Jul 01, 2010 2:42 pm
by ray.wurlod
My preference would be a Column Generator stage.

dummy

Posted: Fri Jul 02, 2010 5:34 am
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.