Property |
Value |
Database schema name |
dbo |
Database table name |
DimDepartmentGroup |
Friendly name |
Department |
Table name |
dbo_DimDepartmentGroup |
Table type |
Table |
Is loaded |
|
Relation name |
Child (foreign key) columns |
Parent name |
Parent type |
Parent (primary key) columns |
FK_DimDepartmentGroup_DimDepartmentGroup |
ParentDepartmentGroupKey |
DimDepartmentGroup |
Table |
DepartmentGroupKey |
Total: 1 parent relationship(s)
Relation name |
Parent (primary key) columns |
Child name |
Child type |
Child (foreign key) columns |
FK_FactFinance_DimDepartmentGroup |
DepartmentGroupKey |
FactFinance |
Table |
DepartmentGroupKey |
FK_DimDepartmentGroup_DimDepartmentGroup |
DepartmentGroupKey |
DimDepartmentGroup |
Table |
ParentDepartmentGroupKey |
Total: 2 child relationship(s)
Name |
Type |
Computed column expression |
DepartmentGroupKey |
System.Int32 |
|
ParentDepartmentGroupKey |
System.Int32 |
|
DepartmentGroupName |
System.String |
|
Total: 3 column(s)