Table: Currency

CollapseAll image

Collapse image Table properties


 Property   Value 
 Database schema name    
 Database table name   Currency 
 Friendly name   Currency 
 Table name   dbo_DimCurrency 
 Table type   View 
 Is loaded   True 

Collapse image Query definition


SELECT     CurrencyKey, CurrencyAlternateKey, CurrencyName
FROM         DimCurrency

Collapse image Parent relations


No relationships exist

Collapse image Child relations


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)

Collapse image Columns


Name  Type  Computed column expression 
CurrencyKey System.Int32  
CurrencyAlternateKey System.String  
CurrencyName System.String  
Total: 3 column(s)

Collapse image See also


About this documentation