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

17.4.2 About Exchange Rates T2T for the STG_FORWARD_EXCHG_RATES table

T2T_FSI_EXCHANGE_RATES_FRWD is added in the OFSDF 8.1.0.0.0 release. The Exchange Rates T2T for the STG_FORWARD_EXCHG_RATES table and its description are as follows.

Table 41: Exchange Rates T2T for the STG_FORWARD_EXCHG_RATES table and its Description

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

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

Note:

Only this T2T is part of the OOB Runchart.

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

Table 42: 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_FRWD