FactOrders.ExtendedAmtUSD Lineage

Metadata hierarchy: MDWT_Adventure_Works_Demo » MDWT_AdventureWorksDW » FactOrders » Lineage

Lineage of FactOrders.ExtendedAmtUSD inside package FactOrders

OrderTask NameTask TypeTask Description
1Source from xtractOLE DB SourceOLE DB Source
2Allocate Tax & FreightDerived ColumnUpdates column values using expressions
3Lookup CurrencyLookupLooks up values in a reference dataset by using exact matching.
4Currency conversion and key cleanupDerived ColumnUpdates column values using expressions
5Lookup SalesReasonIDLookupLooks up values in a reference dataset by using exact matching.
6Fix up SalesReasonIDDerived ColumnUpdates column values using expressions
7Product LookupLookupLooks up values in a reference dataset by using exact matching.
8Calculate TotalProductCostDerived ColumnUpdates column values using expressions
9Lookup Order DateLookupLooks up values in a reference dataset by using exact matching.
10Compute DueDateKeyDerived ColumnUpdates column values using expressions
11Lookup PromotionLookupLooks up values in a reference dataset by using exact matching.
12Lookup CurrrencyKeyLookupLooks up values in a reference dataset by using exact matching.
13Union AllUnknownMerges multiple datasets.
14Lookup EmployeeLookupLooks up values in a reference dataset by using exact matching.
15Lookup OrderInfoLookupLooks up values in a reference dataset by using exact matching.
16Add Audit Keys to flowDerived ColumnUpdates column values using expressions
17FactOrders StageOLE DB DestinationOLE DB Destination