Property |
Value |
Database schema name |
|
Database table name |
Destination Currency |
Friendly name |
Destination Currency |
Table name |
DimDestinationCurrency |
Table type |
View |
Is loaded |
True |
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)) |
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)
Name |
Type |
Computed column expression |
CurrencyKey |
System.Int32 |
|
CurrencyAlternateKey |
System.String |
|
CurrencyName |
System.String |
|
LCID |
System.String |
|
Total: 4 column(s)