User defined component and stage

monaz · Post by **monaz** » Thu Aug 27, 2009 1:24 am

Hi,

Can anyone help me out with any scenario where we use user defined stage?

Please correct if my understanding is wrong user defined stage it something like we can create our own stage like sort, aggregator ?

Please let me know an example if any one has worked on user defined stages..

ArndW · Post by **ArndW** » Thu Aug 27, 2009 3:58 am

User defined stages are a way of extending DataStage functionality; if you need something specific done which cannot be handled otherwise you can write your own stage. It is much more complex and involved than just using an external routine or BuildOp. We use one here which performs a two-phase-commit functionality with MQSeries - functionality we need but which isn't present in the DataStage product.

arnabdey · Post by **arnabdey** » Mon Aug 31, 2009 11:34 am

Let us say you need some customized looping logic to be implemented with each of the incoming records (other than sort or aggregate) for which I think you do not have any dedicated DS stages.