Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » FactExchangeRates » Lineage
| Order | Task Name | Task Type | Task Description |
| 1 | Source from staging table | OLE DB Source | OLE DB Source |
| 2 | Lookup Date | Lookup | Looks up values in a reference dataset by using exact matching. |
| 3 | Map lookup failures to -1 | Derived Column | Updates column values using expressions |
| 4 | Lookup Currency | Lookup | Looks up values in a reference dataset by using exact matching. |
| 5 | Lookup failures to -1 | Derived Column | Updates column values using expressions |
| 6 | Add Audit Keys to flow | Derived Column | Updates column values using expressions |
| 7 | Row Count | Row Count | Counts the rows in a dataset. |
| 8 | FactExchangeRates | OLE DB Destination | OLE DB Destination |