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 |