FX_RATE_MARKET_DATA

The FX_RATE_MARKET_DATA table contains all the FX Rates. It is an isolated table and not part of any cube facts.

Column Name	Type	Not Null	Description
AS_OF_DATE	DATE	Y	Timestamp (at close of business) for the data.
MARKET_DATA_SET	STRING	Y	String defining the market data set.
BASE_CCY	STRING	Y	The left side of the currency pair.
COUNTER_CCY	STRING	Y	The right side of the currency pair.
QUOTE	DOUBLE	Y	Forex rate between the two currencies.

Unique Key

If the default value is marked as empty, it means that the default value is ‘null’ for nullable fields, and that a value needs to be explicitly set for non-nullable fields. ↩