Tutorial - Dimension Employee
Code | _EMP |
|---|---|
Name | Employee |
Table Name | dim_employees |
Description | details on employees |
Source priority
HR extract
CRM extract
Content
Field name | Data Type | Description |
|---|---|---|
Employee_id | string | |
employee_manager_id | string | |
employee_full_name | string | if source = HR, concat(first_name, ' ', last_name); if source = CRM, ‘name’ |
employee_is_in_crm | bool | if employee is in source CRM, then true Else false |
employee_is_in_hr_system | bool | if employee is in source HR system, then true Else false |
snapshot_date | datetime | link to point in time table |