IICS:Mapping example with a Normalizer and Aggregator Transformation

#iics #etlguru #antosh IICS:Mapping example with a Normalizer and Aggregator Transformation A relational table includes the quarterly unit sales for each store. To calculate the annual unit sales for each store, use a Normalizer transformation to create a row for each quarter. Then, use an Aggregator transformation to aggregate the quarterly sales for each store. The source data includes the following rows: StoreNo   Q1   Q2   Q3   Q4 Year 1001      30   50   48   80 2014 1022     100  120  125  140 2014 1190      80  108  123  134 2014 The task writes the following data to the target: StoreNo   AnnualSalesbyStore 1001       208 1022       485    1190       445