| Property |
Value |
| Database schema name |
|
| Database table name |
Currency |
| Friendly name |
Currency |
| Table name |
dbo_DimCurrency |
| Table type |
View |
| Is loaded |
True |
SELECT CurrencyKey, CurrencyAlternateKey, CurrencyName
FROM DimCurrency |
| Relation name |
Parent (primary key) columns |
Child name |
Child type |
Child (foreign key) columns |
| FK_FactResellerSales_DimCurrency |
CurrencyKey |
FactResellerSales |
Table |
CurrencyKey |
| FK_FactInternetSales_DimCurrency |
CurrencyKey |
FactInternetSales |
Table |
CurrencyKey |
| FK_FactCurrencyRate_DimCurrency |
CurrencyKey |
Currency Rate Facts |
View |
CurrencyKey |
| FactSalesSummary-DimCurrency |
CurrencyKey |
Sales Summary Facts |
View |
CurrencyKey |
Total: 4 child relationship(s)
| Name |
Type |
Computed column expression |
| CurrencyKey |
System.Int32 |
|
| CurrencyAlternateKey |
System.String |
|
| CurrencyName |
System.String |
|
Total: 3 column(s)