1. Data Quality
  2. Balance Reconciliation
  3. Reconciliation Rules
  4. Execution of Rule
  5. Prerequisites

2.6.3.1 Prerequisites

  • The SCD executable should be present under <installation home>ficdb/bin. The file name is scd.
  • The user executing the SCD component should have execute rights on the file mentioned as prerequisite in point 2.
  • The setup tables accessed by SCD component are SYS_TBL_MASTER and SYS_STG_JOIN_MASTER.

SYS_TBL_MASTER stores the information like which is the source stage table and the target dimension tables. The source sometimes can be the database views which could be simple or a complex view.

SYS_STG_JOIN_MASTER stores the information like which source column is mapped to which column of a target dimension table. It makes use of data base sequence to populate into surrogate key columns of dimension tables.