constrains,derivations,stage variables which one is executes
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 44
- Joined: Fri Mar 16, 2007 5:51 am
constrains,derivations,stage variables which one is executes
hi guys,
i am new to datastage may i know which one is executes first
constrains
derivations
stage variables execution order
i am new to datastage may i know which one is executes first
constrains
derivations
stage variables execution order
seshu
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Stage variables first followed by derivations followed by constraints.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You might find this information enlightening. The same question was asked all those years ago.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: constrains,derivations,stage variables which one is exec
hello,
the stage variable declaration in stage properties,then definition and then constraints.
just like in any language.
declaration,definition and usage of the variable.
the stage variable declaration in stage properties,then definition and then constraints.
just like in any language.
declaration,definition and usage of the variable.
vmcburney wrote:Stage variables first followed by derivations followed by constraints.
Actually, a big 'nope' to both of you.sachin1 wrote:the stage variable declaration in stage properties,then definition and then constraints.
As answered all those many moons ago, for those three objects it goes: stage variables, constraints then derivations. It don't bother to derivate constrained rows.
The Full Wurlod is in the linked post.
-craig
"You can never have too many knives" -- Logan Nine Fingers
"You can never have too many knives" -- Logan Nine Fingers
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
We haven't had that spirit here since nineteen sixty nine.
And still those voices keep calling from far away: wake you up in the middle of the night just to hear them say...
And still those voices keep calling from far away: wake you up in the middle of the night just to hear them say...
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
-
- Participant
- Posts: 3593
- Joined: Thu Jan 23, 2003 5:25 pm
- Location: Australia, Melbourne
- Contact:
Sheesh was I wrong. Of course you wouldn't derive an output row until you had worked out what output links that row is on. Thanks Craig.
Certus Solutions
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Blog: Tooling Around in the InfoSphere
Twitter: @vmcburney
LinkedIn:Vincent McBurney LinkedIn
Wurn Snell of Colitas...
Worth a read for the tale of Mr. Wurn Snell http://www.straightdope.com/classics/a5_001.html
ray.wurlod wrote:We haven't had that spirit here since nineteen sixty nine.
And still those voices keep calling from far away: wake you up in the middle of the night just to hear them say...