1. User Guide
  2. Dimension Loading Process
  3. Hierarchy Transformation
  4. Tables Used by the Hierarchy Flattening Transformation

4.1.2 Tables Used by the Hierarchy Flattening Transformation

The following tables are used by the Hierarchy Flattening Transformation process:

  • REV_HIERARCHIES: This is the master table for hierarchies with one row per hierarchy.
  • REV_DIMENSIONS_B: This is the master table for dimensions with one row per dimension.
  • REV_HIER_DEFINITIONS: FLATTENED_ROWS_COMPLETION_CODE column is checked to determine whether the hierarchy is to be processed.
  • DIM_<DIMENSIONNAME>_HIER: This table stores the hierarchy data and is the source for the transformation.
    Example:
    • DIM_PRODUCTS_HIER: This table stores the hierarchy data of one or more Product Hierarchies created on the Product dimension (a seeded dimension).
  • REV_HIER_FLATTENED: This is the output table for the transformation into which the flattened hierarchy data gets populated.