| |
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.
|
| May 05, 2007 22:20:54 |
#5 |
| hanug |
Member Since: June 2006 Total Comments: 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. |
| |
Back To Question | |
