To Convert Datatype of one 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
madhavamaganti
Participant
Posts: 21
Joined: Thu Jun 25, 2009 10:28 am
Location: Andhra Pradesh

To Convert Datatype of one column.

Post by madhavamaganti »

I am Having 10 columns.

I want to change only one column datatype.

In susch cases which stage i have to choose.In modify and transformer

Stages.

Data Conversions May be any way ( any to any ).Plz May i know the

reson.For choosing the particular stage.
Madhava
Ravi.K
Participant
Posts: 209
Joined: Sat Nov 20, 2010 11:33 pm
Location: Bangalore

Post by Ravi.K »

Modify has better performance compare to Transformer.
Cheers
Ravi K
madhavamaganti
Participant
Posts: 21
Joined: Thu Jun 25, 2009 10:28 am
Location: Andhra Pradesh

Post by madhavamaganti »

Ravi.K wrote:Modify has better performance compare to Transformer.

But i am asking for only one column.

Ru sure abt the answer ?
Madhava
myukassign
Premium Member
Premium Member
Posts: 238
Joined: Fri Jul 25, 2008 8:55 am

Post by myukassign »

yes it is...

no matter one or 100 you can use modify stage. You don't need a transformer for such tasks.
madhavamaganti
Participant
Posts: 21
Joined: Thu Jun 25, 2009 10:28 am
Location: Andhra Pradesh

Post by madhavamaganti »

myukassign wrote:yes it is...

no matter one or 100 you can use modify stage. You don't need a transformer for such tasks.
Thank u Very much..! For Clarifying My Question.
Madhava
Post Reply