DW Handbook

Name Type Transformation Category Description
Unary 1 1:1 Tuple level 1:1 transformation which includes most operations in the DW domain for which the every output tuple corrosponds to a single input tuple
Unary 2 N:1 Tuple level N:1 where a combination of N input tuples produce a single output tuple, e.g Aggregates
Unary 3 1:N Tuple level 1:N: a single input tuple is transformed into more N tuples, e.g Unpivoting/unfolding
N-Ary M:1 Relation level: M Relations are combined to produce a single new Relation
Router 1:M Relation level: a single input relation is transformed to M output relations based on a certain condition

Back