Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » DimEmployee » Lineage
| Order | Task Name | Task Type | Task Description |
| 1 | Source from HR Employee | OLE DB Source | OLE DB Source |
| 2 | Multicast | Multicast | Creates copies of a dataset. |
| 3 | Decodes and prettification | Derived Column | Updates column values using expressions |
| 4 | Multicast 1 | Multicast | Creates copies of a dataset. |
| 5 | Sort by ManagerID | Unknown | Sorts data. |
| 6 | Join in Mgr Name | Unknown | Merges data from two datasets by using a join. |
| 7 | Sort by EmployeeID | Unknown | Sorts data. |
| 8 | Join in Dept info | Unknown | Merges data from two datasets by using a join. |
| 9 | Join in Sales Territory | Unknown | Merges data from two datasets by using a join. |
| 10 | More Decodes and Prettification | Derived Column | Updates column values using expressions |
| 11 | Row Metadata | Derived Column | Updates column values using expressions |
| 12 | Row Count | Row Count | Counts the rows in a dataset. |
| 13 | OLE DB Destination | OLE DB Destination | OLE DB Destination |