constrains,derivations,stage variables which one is executes

seshikumar · Post by **seshikumar** » Mon Jun 18, 2007 12:35 am

hi guys,
i am new to datastage may i know which one is executes first
constrains
derivations
stage variables execution order

vmcburney · Post by **vmcburney** » Mon Jun 18, 2007 12:51 am

Stage variables first followed by derivations followed by constraints.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 18, 2007 1:05 am

You might find this information enlightening. The same question was asked all those years ago.

sachin1 · Post by **sachin1** » Mon Jun 18, 2007 2:19 am

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.

chulett · Post by **chulett** » Mon Jun 18, 2007 6:16 am

vmcburney wrote:Stage variables first followed by derivations followed by constraints.

sachin1 wrote:the stage variable declaration in stage properties,then definition and then constraints.

Actually, a big 'nope' to both of you.

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.

ray.wurlod · Post by **ray.wurlod** » Mon Jun 18, 2007 2:36 pm

Derivate?!!

chulett · Post by **chulett** » Mon Jun 18, 2007 3:35 pm

Yes, some of us just make up words as the spirit moves us. :D

ray.wurlod · Post by **ray.wurlod** » Mon Jun 18, 2007 7:13 pm

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

vmcburney · Post by **vmcburney** » Mon Jun 18, 2007 8:57 pm

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.

jgreve · Post by **jgreve** » Tue Jun 19, 2007 12:08 pm

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

DSXchange

constrains,derivations,stage variables which one is executes

constrains,derivations,stage variables which one is executes

Re: constrains,derivations,stage variables which one is exec

Wurn Snell of Colitas...