1. User Guide
  2. Utilities
  3. Stage Synchronization
  4. Dimension Member Synchronization

4.4.2 Dimension Member Synchronization

The SYNCHRONIZE_STAGE procedure synchronizes the dimension member tables and Stage tables using default values for member descriptions and other information columns. This procedure performs the following functions:
  1. Checks the specified table (Stage Table) for new dimension members in each of that table's key dimension columns and adds the new dimension value as leaf members to the respective dimension member tables.
  2. Adds the new dimension member to the corresponding attribute tables with default values for mandatory attributes.
  3. When new dimension members are added to the dimension tables these members include 'No Description_<ID column Value>' in the DESCRIPTION column and contain default values for mandatory attributes.