constraint for each output link

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
cetzhbo
Premium Member
Premium Member
Posts: 38
Joined: Tue Aug 28, 2007 10:20 am

constraint for each output link

Post by cetzhbo »

Hello Gurus,

for transformer stage, constraint for each output link is in effect before derivation or after derivation of output column?

thanks very much!
ray.wurlod
Participant
Posts: 54607
Joined: Wed Oct 23, 2002 10:52 pm
Location: Sydney, Australia
Contact:

Post by ray.wurlod »

Output column derivations are only performed if the link's constraint expression is satisfied.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
OddJob
Participant
Posts: 163
Joined: Tue Feb 28, 2006 5:00 am
Location: Sheffield, UK

Post by OddJob »

Looking at the generated C++ from a transformer, things happen in the following order:

Stage Variables evaluated

Constraint evaluated
If Constraint is True, the output column derivations are performed
If Constraint is False, output for column is skipped - no derivations are made

Hope this helps!
cetzhbo
Premium Member
Premium Member
Posts: 38
Joined: Tue Aug 28, 2007 10:20 am

Post by cetzhbo »

thanks, but does stage variable/constraint/output derivation are evaluated row by row ?
chulett
Charter Member
Charter Member
Posts: 43085
Joined: Tue Nov 12, 2002 4:34 pm
Location: Denver, CO

Post by chulett »

Yes.
-craig

"You can never have too many knives" -- Logan Nine Fingers
cetzhbo
Premium Member
Premium Member
Posts: 38
Joined: Tue Aug 28, 2007 10:20 am

Post by cetzhbo »

thanks, I got it
Post Reply