Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » DimProduct » Lineage
| Order | Task Name | Task Type | Task Description |
| 1 | Source from Product and ProductModel | OLE DB Source | OLE DB Source |
| 2 | Multicast | Multicast | Creates copies of a dataset. |
| 3 | Subcategory | Lookup | Looks up values in a reference dataset by using exact matching. |
| 4 | Union All | Unknown | Merges multiple datasets. |
| 5 | Trim some strings | Derived Column | Updates column values using expressions |
| 6 | Decodes and Prettification | Derived Column | Updates column values using expressions |
| 7 | Row Metadata | Derived Column | Updates column values using expressions |
| 8 | Row Count | Row Count | Counts the rows in a dataset. |
| 9 | DimProduct | OLE DB Destination | OLE DB Destination |