1. User Guide
  2. Exchange Rates Tables
  3. About Exchange Rates T2Ts (Result Table)
  4. About Exchange Rates T2T for the STG_EXCHANGE_RATE_HIST table

17.4.1 About Exchange Rates T2T for the STG_EXCHANGE_RATE_HIST table

Exchange Rates T2T for the STG_EXCHANGE_RATE_HIST table and its description are as follows.

Table 17-1 Exchange Rates T2T for the STG_EXCHANGE_RATE_HIST table and its Description

T2T Name T2T Description
T2T_FSI_EXCHANGE_RATES This T2T stores history of the exchange rates between two currencies sourced through the STG_EXCHANGE_RATE_HIST table.

The mapping details for the Exchange Rates T2T are as follows.

Note:

Ensure to verify and load data into the STG_EXCHANGE_RATE_HIST table using the Table to Table (T2T) component of Oracle Financial Services Analytical Applications Infrastructure (OFSAAI) framework.

Table 17-2 Mapping details for the Exchange Rates T2T

Source Table Name Logical Stage Table Name Fact Table Name Logical Fact Table Name T2T Name
VW_FSI_RATE_TRI ANGULATION FSI Rate Triangulation View FSI_EXCHANGE_ RATES FSI Exchange Rates T2T_FSI_EXCHANGE_ RATES