Table: Currency Rate Facts

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name    
 Database table name   Currency Rate Facts 
 Friendly name   Currency Rate Facts 
 Table name   dbo_FactCurrencyRate 
 Table type   View 
 Is loaded   True 

Collapse image Query definition


SELECT     CurrencyKey, DateKey, AverageRate, EndOfDayRate
FROM         dbo.FactCurrencyRate

Collapse image Parent relations


Relation name  Child (foreign key) columns  Parent name  Parent type  Parent (primary key) columns 
FK_FactCurrencyRate_DimCurrency CurrencyKey Currency View CurrencyKey
FactCurrencyRate-DimDestinationCurrency CurrencyKey Destination Currency View CurrencyKey
Currency Rate Facts-DimDate DateKey DimDate Table DateKey
Total: 3 parent relationship(s)

Collapse image Child relations


No relationships exist

Collapse image Columns


Name  Type  Computed column expression 
CurrencyKey System.Int32  
AverageRate System.Double  
EndOfDayRate System.Double  
DateKey System.Int32  
Total: 4 column(s)

Collapse image See also


About this documentation