What is the order of execution done internally in the transformer with the stage editor having input links on the lft hand side and output links?

  • Interview Candidate
  • 22
  • 17825

Showing Answers 1 - 22 of 22 Answers

gagan8877

  • May 8th, 2007
 

There is only one Primary input link to the Transformer and there can be many reference input links and there can be many output links. U can output to multiple output links by defining constraints on the output links.
U can edit the order of the input and output links from the Link ordering tab in the transformer stage properties dialog.

  Was this answer useful?  Yes

qwert123

  • Jun 29th, 2009
 

Within the transformer we have a toolbar which has following options: stage properties show all or selected relations constraints cut copy paste load column definition save column definition find/replace column auto-match show/hide stage variables input link execution order output link execution order. So we can set the order of execution of input and output links using the toolbar.

Thanks,
Soni

  Was this answer useful?  Yes

Bublu

  • Aug 4th, 2009
 

 The following is the order of execution done internally in the transformer:

* Stage variables

*Constraints

*Derivations or Expressions

Note: We can't change the order of execution by using Link Ordering option. Link

Ordering is no where related to this.

  Was this answer useful?  Yes

Amit_Mishra

  • Apr 11th, 2011
 

Please follow the following details:
Stage Variables-> Constraints-> Derivations/Expressions.
Link ordering is mainly based to which link you want to process first.
Link Ordering is mainly useful for Funnel,Change Capture Stages where you want your inputs in any specific order. Transformer mainly has One input.

Regards,
Amit

  Was this answer useful?  Yes

ajay kumar

  • Oct 25th, 2017
 

Order of execution inside transformer
Derivation, stage variables then constraint

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions