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. 



December 12, 2006 23:17:32 #2
 raghuvamsi   Member Since: Visitor    Total Comments: N/A 

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

     

 

Back To Question