DataStage - What are Stage Variables, Derivations and Constants?

GeekInterview.com > Interview Questions > Data Warehousing > DataStage

Go To First | Previous Question | Next Question

DataStage | Question 9 of 374

What are Stage Variables, Derivations and Constants?

Stage Variable - An intermediate processing variable that retains value during read and doesnt pass the value into target column.

Derivation - Expression that specifies value to be passed on to the target column.

Constant - Conditions that are either true or false that specifies flow of data with a link.

Total Answers and Comments: 8

Last Update: February 12, 2008

Sponsored Links

Best Rated Answer

—

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

October 13, 2005 04:46:21

siva

RE: What are Stage Variables, Derivations and Constant...

Not 'constant' ..but 'Constraints'

Is this answer useful? Yes | No

December 21, 2006 23:17:32

raghuvamsi

RE: What are Stage Variables, Derivations and Constant...

stage variables :- is the tempry memomery area.

derivation :- where u apply the business rule.

constarins :- where u apply conditions

order of execution is :-

constrains

derivation

stage vraiables

Is this answer useful? Yes | No

March 29, 2007 03:34:29

ADITI

RE: What are Stage Variables, Derivations and Constant...

stage variable is a variable that executes locally within the stage.

constraint is like a filter condition which limits the number of records coming from input according to business rule.

derivation is like expression which is used to modify or get some values from input columns.

Execution order is stage variable,constraint,derivation.........

Is this answer useful? Yes | No

April 20, 2007 11:12:22

sss

RE: What are Stage Variables, Derivations and Constant...

Order of execution is :
Constrains
Stage variables and Derviations

Is this answer useful? Yes | No

May 06, 2007 22:20:54

hanug

Member Since: June 2006 Contribution: 24

RE: What are Stage Variables, Derivations and Constant...

Hi:

I dont think so previous posts are correct.

The correct order is :

1. stage variable
2. derivation
3. Constraint(it is like a condition in the transformer). Before sending any info to targer, we can filter the data by using stage variable as a constraint or condtion.

Hanu.

Is this answer useful? Yes | No

September 06, 2007 06:19:13

Sreenubabu P

RE: What are Stage Variables, Derivations and Constant...

Hi
Your answer is wrong for order of execution of stage variables, constraints and derivations...

the right order is..

stage variables
constraints
Derivations

Is this answer useful? Yes | No

January 28, 2008 02:08:03

manoharkolukula

Member Since: January 2008 Contribution: 29

RE: What are Stage Variables, Derivations and Constants?

the order of execution is stage variable, constraints and dervations.

Is this answer useful? Yes | No

February 12, 2008 01:52:37

manoharkolukula

Member Since: January 2008 Contribution: 29

RE: What are Stage Variables, Derivations and Constants?

all r correct one only

Is this answer useful? Yes | No

Go To Top