| |
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.
|
| March 03, 2007 03:34:29 |
#3 |
| ADITI |
Member Since: Visitor Total Comments: N/A |
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.........
|
| |
Back To Question | |
