SEQUENCE OF OPERATION IN TRANSFORMER

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
arnie_nits
Participant
Posts: 101
Joined: Mon Aug 13, 2007 2:32 am

SEQUENCE OF OPERATION IN TRANSFORMER

Post by arnie_nits »

Hi,

I just want to know the sequence in which the transformer components operate i.e Stage variable,constraints and derivation.Which one operates 1st.....

Regards
Arnie
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

1. Before-stage trigger.
2. Input link.
3. Stage variables, top down in their grid.
4. For each output link, the constraint expression is evaluated and, if satisfied, the output column derivation expressions are evaluated and the row put onto the output.
5. If there is an otherwise/log output link and the current row has not thus far been put onto any prior output link, then the output column derivation expressions on the otherwise/log output link are evaluated and the row put onto that output.
6. After-stage trigger.

While all that is going on, any row that causes an exception to be raised will be sent to the reject output link (if any).
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Post Reply