*Once a snapshot Fact table has been defined in the metadata and created in the database, an update procedure can be generated to handle the update of the Fact table.

You can also generate an update procedure via a template, refer to Rebuilding Update Procedures for details.

Generating a Procedure

  1. To generate a procedure, right-click the Fact table in the left pane and select Properties.
  2. Click the Rebuild button to start the process of generating the new procedure.
  3. A series of questions is asked during the procedure generation based on the type of load information.
  4. If a detail method was used for the creation of the snapshot table, refer to Generating the Detail Fact Update Procedure for details.
  5. However, if a rollup method was used for the creation of the snapshot table, refer to Generating the Rollup Fact Update Procedure for details.
  • No labels