GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  GeekInterview.com  >  Interview Questions  >  Data Warehousing  >  DataStage

 Print  |  
Question:  What are Stage Variables, Derivations and Constants? 



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



September 09, 2007 06:19:13 #6
 Sreenubabu P   Member Since: Visitor    Total Comments: N/A 

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
     

 

Back To Question