Stage Variables and Constants

Question

Describe the term Derivations, Stage Variables and Constants?

Answer 1

a) Derivation - Expression which specifies value that can be passed on to the target column.

b) Stage Variable – It is defined as an intermediate processing variable which retains the value during read and does not pass the value to the target column.

c) Constant - Conditions that are either true or false which specifies that flow of the data along with a link.