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 |
SELECT CurrencyKey, DateKey, AverageRate, EndOfDayRate
FROM dbo.FactCurrencyRate |
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)
Name |
Type |
Computed column expression |
CurrencyKey |
System.Int32 |
|
AverageRate |
System.Double |
|
EndOfDayRate |
System.Double |
|
DateKey |
System.Int32 |
|
Total: 4 column(s)