What are Stage Variables, Derivations and Constants?
Stage Variable – An intermediate processing variable that retains value during read anddoesn’t pass the value into target column.Constraint – Conditions that are either true or false that specifies flow of data with a link.Derivation – Expression that specifies value to be passed on to the target column.