| 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)