1. User Guide
  2. Data Loaders
  3. Transaction Summary Table Loader
  4. Populating Stage Tables

5.10.2 Populating Stage Tables

Data can be loaded into staging tables through F2T component of OFSAAI. After data is loaded, check for data quality within the staging tables, before moving into OFSAA processing tables. Data quality checks can include:

  • Number of records between external system and staging transaction summary tables.
  • Valid list of values in code columns of staging.
  • Valid list of values in dimension columns like product, organization unit, general ledger, and so on. These members should be present in the respective dimension tables.
  • Valid list of values in dimension columns like product, organization unit, general ledger, and so on. These members should be present in the respective dimension tables.
  • Valid values for other significant columns of staging tables.