DimEmployee.DepartmentGroup

Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » DimEmployee

Attribute DimEmployee.DepartmentGroup

Property NameValue
Commentssee above
DescriptionDepartment group
Display NameDepartmentGroup
ETL RulesJoin on DepartmentID
Example ValuesSales and Marketing
Is Audit Subsystem
SCD Type2
Source Datatypenvarchar(50)
Source Field NameGroupName
Source SchemaHumanResources
Source SystemAW
Source TableDepartment
Table Type
Used in schemas
View Name

Also Found In

  • A list tables where this item is also located can be found here.

    • More information about the source and ETL of this column can be found in:

  • Package: DimEmployee