1. User Guide
  2. Utilities
  3. Reverse Population
  4. Reverse Population Procedure

4.1.2 Reverse Population Procedure

The REVERSE_POPULATION package populates the OFSA legacy dimension tables from new dimension tables.

The procedure performs the following functions:

  • Gets the list of source and target tables. The source tables for given dimension is stored in REV_DIMENSION_B table. The OFSA target table for a given dimension is stored in OFSA_CATALOG_OF_LEAVES.
  • The REVERSE POPULATION transposes the seeded attributes, leaf members and hierarchy data stored in the form of rows (new dimension table structure) to columns (OFSA).
  • All exception messages are logged in the FSI_MESSAGE_LOG table.