MDWT_AdventureWorksDW.FactExchangeRates


Metadata hierarchy: MDWT_Adventure_Works_Demo ยป MDWT_AdventureWorksDW


Attributes in FactExchangeRates

Column NameData TypeIs KeyShort description
CurrencyKeysmallintKey to Currency dim
DateKeyintKey to Date dim
InsertAuditKeyintKey to Audit dimension for row insertion
UpdateAuditKeyintKey to Audit dim for row last updated
CloseRatefloatMarket close (end of day) exchange rate from USD to local currency
AvgRatefloatAverage daily exchange rate from USD to local currency

Internal data warehouse auditing attributes

Column NameData Type