DSXchange

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.

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.

I particularly like the inbuilt small lookup table (integer to string or string to integer) capability.

ArndW wrote:while the modify stage is an OSH call, transform stages are compiled c programs that are executed at runtime.

This means that Modify stage has better performance than the transformer as the transformer is executed at the runtime?

yes at run time modify stage will perform more than transformer.(execution)

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.

u can search this forum definitely, for more info.

... 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".