What's the advantage of Modify stage?

[mavrick21]

Hello all,

I was wondering why one should use modify stage when other stages can be used instead of modify stage?

As per my understanding renaming columns, dropping columns, changing datatype can be achieved using Copy stage instead of Modify Stage.

I know Modify stage performs better since it's a primitive stage. What are the other advantages of Modify stage over others?

Thanks for your time.

[Sreenivasulu]

Better change datatype using 'modify' stage .

Regards
Sreeni

[tjr]

Modify and transformer stages have comparable performance. The advantage of the modify stage clearly is that it fully supports RCP and parameterized commands. With it you can design much more generic jobs than just with the transformer stage.

[mavrick21]

Thanks for your replies.

tjr,
Could you please give me an example of parameterized commands?

Again thanks for your time.

[jhmckeever]

You might want to look at Andy Sorrell's Modify Stage video in the Learning Center:

learningcenter/video/ModifyStage.php

[tjr]

Thanks for your replies.

tjr,
Could you please give me an example of parameterized commands?

Again thanks for your time.

the whole modify specification or parts of it can just be a job parameter that is resolved at run-time.