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.