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)