when we can drop/modify column and do null Handling using Transformer, what are the other(or unique) uses of a Modify stage, please let me know, thank you.
Ulab----------------------------------------------------
help, it helps you today or Tomorrow
The modify stage is the original Orchestrate stage that allowed modification of column values, the transform stage came afterwards. They have a number of similarities; while the modify stage is an OSH call, transform stages are compiled c programs that are executed at runtime.
Certainly, performance of modify stage is better than transformer .
but transformer has more functions than modify stage , and can perform several work at one time .
if you totally use modify stage instead of transforms in complex jobs , it may make your maintenance harder.
... but maybe U is not interested in this particular question. U is one of our members. The second person personal pronoun in English is spelled "you".
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.