DataStage - What is the order of execution done internally in the transformer with the stage editor having input

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 37 of 390

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?

Total Answers and Comments: 6

Last Update: August 04, 2009

Sponsored Links

Best Rated Answer

—

No best answer available. Please pick the good answer available or submit your answer.

September 29, 2005 13:00:01

malneedi

Member Since: September 2005 Contribution: 7

RE: What is the order of execution done internally in ...

Stage variables constraints and column derivation or expressions.

Is this answer useful? Yes | No

May 08, 2007 12:27:40

gagan8877

Member Since: May 2007 Contribution: 8

RE: What is the order of execution done internally in ...

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.

Is this answer useful? Yes | No

0 1

Overall Rating: -1

July 29, 2008 03:53:24

manoharkolukula

Member Since: January 2008 Contribution: 32

RE: 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?

ru asking about sv constraints derivations.... or something.

Is this answer useful? Yes | No

July 29, 2008 03:54:48

manoharkolukula

Member Since: January 2008 Contribution: 32

RE: 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?

That totally depends on link ordering we can change the link ordering.

Is this answer useful? Yes | No

June 29, 2009 01:56:48

qwert123

Member Since: March 2009 Contribution: 7

RE: 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?

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

Is this answer useful? Yes | No

August 04, 2009 02:28:24

Bublu

Member Since: August 2009 Contribution: 1

RE: 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?

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.

Is this answer useful? Yes | No

Go To Top

User Name		Remember Me?
Password

Question Bank