Table: Destination Currency

CollapseAll image

Collapse image Table properties


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

Collapse image Query definition


SELECT     CurrencyKey, CurrencyAlternateKey, CurrencyName, 
                      CASE WHEN CurrencyAlternateKey = 'ARS' THEN '11274' WHEN CurrencyAlternateKey = 'AUD' THEN '3081' WHEN CurrencyAlternateKey = 'DEM' THEN
                       '1031' WHEN CurrencyAlternateKey = 'GBP' THEN '2057' WHEN CurrencyAlternateKey = 'MXN' THEN '2058' WHEN CurrencyAlternateKey = 'CAD' THEN
                       '4105' WHEN CurrencyAlternateKey = 'SAR' THEN '1025' WHEN CurrencyAlternateKey = 'EUR' THEN '2067' WHEN CurrencyAlternateKey = 'FRF' THEN
                       '1036' WHEN CurrencyAlternateKey = 'BRL' THEN '1046' WHEN CurrencyAlternateKey = 'JPY' THEN '1041' WHEN CurrencyAlternateKey = 'CNY' THEN
                       '2052' WHEN CurrencyAlternateKey = 'VEB' THEN '16394' WHEN CurrencyAlternateKey = 'USD' THEN '1033' END AS LCID
FROM         dbo.DimCurrency
WHERE     (CurrencyKey IN
                          (SELECT DISTINCT CurrencyKey
                            FROM          dbo.FactCurrencyRate))

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 
FactCurrencyRate-DimDestinationCurrency CurrencyKey Currency Rate Facts View CurrencyKey
DimOrganization-DimDestinationCurrency CurrencyKey Organization View CurrencyKey
Total: 2 child relationship(s)

Collapse image Columns


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

Collapse image See also


About this documentation