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

4.2.3 Tables Used by the Hierarchy Flattening Process

The following are the tables used by the Hierarchy Flattening 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: The FLATTENED_ROWS_COMPLETION_CODE column is checked to determine if the hierarchy can be processed.
  • DIM_<DIMENSIONNAME>_HIER: This table stores the parent or child hierarchy data and is the source for the transformation. For example, DIM_PRODUCTS_HIER.
  • REV_HIER_FLATTENED: This is the output table for the transformation into which the flattened hierarchy data gets populated.