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.
What's the advantage of Modify stage?
Moderators: chulett, rschirm, roy
-
- Premium Member
- Posts: 892
- Joined: Thu Oct 16, 2003 5:18 am
Re: What's the advantage of Modify stage?
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.
-
- Premium Member
- Posts: 301
- Joined: Thu Jul 14, 2005 10:27 am
- Location: Melbourne, Australia
- Contact:
You might want to look at Andy Sorrell's Modify Stage video in the Learning Center:
learningcenter/video/ModifyStage.php
learningcenter/video/ModifyStage.php
<b>John McKeever</b>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>
Data Migrators
<b><a href="https://www.mettleci.com">MettleCI</a> - DevOps for DataStage</b>
<a href="http://www.datamigrators.com/"><img src="https://www.datamigrators.com/assets/im ... l.png"></a>