14.1.3 Preparation

The details of the Preparation stage are described here.

Currency Exchange Rates provided at the Date Granularity are loaded directly into the processing entity.

Currency Exchange Rates provided for a period are exploded to a Date Granularity and loaded at the Date Granularity level.

After data is populated, if there are missing data points between all possible currency pairs for currencies that are active in the Currency Dimension Entity, data is populated using these methods:

• Inverse
• Triangulation

After data is populated, the Exchange Rate is available in time and date, and date granularity.

Data is flagged if it is arrived at using Inverse or Triangulation methods. This helps you recognize if the rate in use is traceable to a source.