| 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)