8.6 Market Rates
Market reference data connectors bring in essential data like interest rates, FX rates, and inflation indices, required for valuation, discounting, and financial projections.
There are two entities mapped under this category:
- Stage IRC Rates History
- Stage Currency Exchange Rates
In Stage IRC Rates History, the key attributes marked as primary keys (PKs)
are:
- As of Date
- Interest Rate Term Unit Indicator
- Interest Rate Term
- Interest Rate Code Name
The execution parameters to be passed are:
- Input File Name
- Load Identifier
- Data File Specifications ID
In Stage Currency Exchange Rates, the key attributes marked as primary keys (PKs)
are:
- As Of Date
- Effective Date
- Target Currency Code
- Data Source Code
- Source Currency Code
The execution parameters to be passed are:
- Input File Name
- Load Identifier
- Data File Specifications ID
Table 8-7 List of connectors in this category is listed below:
| # | Connector Name | Primary Source | Target | # of fields | # of key fields | # of Direct Mapping | # of variable mapping |
|---|---|---|---|---|---|---|---|
| 1 | Market Rates | Stage IRC Rates | Stage IRC Rates History | 10 | 4 | 5 | 1 |
| 2 | Market Rates | Stage Currency Exchange Rates | Stage Exchange Rates | 9 | 5 | 1 | 3 |