1. User Guide
  2. Data Loaders
  3. Transaction Summary Table Loader
  4. Mapping To OFSAA Processing Tables

5.10.3 Mapping To OFSAA Processing Tables

Following are examples of the pre-defined T2T mappings between the above application staging tables and processing tables:

  • T2T_STG_CARDS_TXNS_SUMMARY: for loading data from STG_CARDS_TXNS_SUMMARY to FSI_D_CREDIT_CARDS_TXNS.
  • T2T_STG_CASA_TXNS_SUMMARY: for loading data from STG_CASA_TXNS_SUMMARY to FSI_D_CASA_TXNS.
  • T2T_LOAN_CONTRACT_TXNS_SUMMARY: for loading data from STG_LOAN_CONTRACT_TXNS_SUMMARY to FSI_D_LOAN_CONTRACTS_TXNS.
  • T2T_STG_MERCHANT_CARD_TXNS_SUMMARY: for loading data from STG_MERCHANT_CARD_TXNS_SUMMARY to FSI_D_MERCHANT_CARDS_TXNS.
  • T2T_STG_OTHER_SERVICE_TXNS_SUMMARY: for loading data from STG_OTHER_SERVICE_TXNS_SUMMARY to FSI_D_OTHER_SERVICES_TXNS.
  • T2T_STG_TERMDEPOSITS_TXNS_SUMMARY: for loading data from STG_TERMDEPOSITS_TXNS_SUMMARY to FSI_D_TERM_DEPOSITS_TXNS.
  • T2T_STG_TRUSTS_TXNS_SUMMARY: for loading data from STG_TRUSTS_TXNS_SUMMARY to FSI_D_TRUSTS_TXNS.

You can view the Database Extract definitions by performing the following steps:

Note:

The Data Management Tools and Data Ingestion were previously known as Data Integrator Framework and Warehouse Designer respectively. These new terminologies are applicable only for OFSAAI versions 7.3.2.3.0 and above.

User can view the extract definitions by going through the following steps:

  1. Navigate to Unified Metadata Manager and select Data Management Tools, and then select, Data Ingestion, and then select Database Extracts section.
  2. In the left pane, expand the application as defined during application installation and click the Data Source defined during application installation.
  3. Expand the required T2T definition to view the Database Extract definitions.

You can view the Source - Target mapping definitions by performing the following steps:

Note:

The Data Management Tools and Data Ingestion were previously known as Data Integrator Framework and Warehouse Designer respectively. These new terminologies are applicable only for OFSAAI versions 7.3.2.3.0 and above.
  1. Navigate to Unified Metadata Manager and select Data Management Tools, and then select, Data Ingestion, and then select Database Extracts section.
  2. In the left pane, expand the application as defined during application installation and click the Data Source defined during application installation.
  3. Expand the required T2T definition to view the extract definition.
  4. Click the required Database Extract definition.
  5. The selected Database Extract definition details are displayed with the available Source - Target mappings under the Source - Target Mappings grid.

Note:

Staging transaction summary tables contain alphanumeric display codes for various IDENTIFIER and CODE columns. T2T mapping looks up in respective dimension tables for fetching an equivalent numeric ID and CODE corresponding to the alphanumeric display code. Hence, these dimension tables should be populated with the alphanumeric display code before executing any data movement tasks.