Property |
Value |
Database schema name |
|
Database table name |
Organization |
Friendly name |
Organization |
Table name |
dbo_DimOrganization |
Table type |
View |
Is loaded |
True |
SELECT o.OrganizationKey, o.ParentOrganizationKey, o.PercentageOfOwnership, o.OrganizationName, o.CurrencyKey, c.CurrencyAlternateKey
FROM DimOrganization AS o INNER JOIN
DimCurrency AS c ON o.CurrencyKey = c.CurrencyKey |
Relation name |
Child (foreign key) columns |
Parent name |
Parent type |
Parent (primary key) columns |
FK_DimOrganization_DimOrganization |
ParentOrganizationKey |
Organization |
View |
OrganizationKey |
DimOrganization-DimDestinationCurrency |
CurrencyKey |
Destination Currency |
View |
CurrencyKey |
Total: 2 parent relationship(s)
Relation name |
Parent (primary key) columns |
Child name |
Child type |
Child (foreign key) columns |
FK_DimOrganization_DimOrganization |
OrganizationKey |
Organization |
View |
ParentOrganizationKey |
FK_FactFinance_DimOrganization |
OrganizationKey |
FactFinance |
Table |
OrganizationKey |
Total: 2 child relationship(s)
Name |
Type |
Computed column expression |
OrganizationKey |
System.Int32 |
|
ParentOrganizationKey |
System.Int32 |
|
PercentageOfOwnership |
System.String |
|
OrganizationName |
System.String |
|
CurrencyAlternateKey |
System.String |
|
CurrencyKey |
System.Int32 |
|
Total: 6 column(s)