[ANSWERED] There is a need to build a DW to make the analysis of shopping behav…

There is a need to build a DW to make the analysis of shopping behaviour practical; customers’ transactions from Data Sources (DSs) are required to be reflected in the DW on a daily basis. This process of reflecting the customer data into DW is called Data Integration (DI) as shown in Figure 1. To implement DI we usually need ETL (Extraction, Transformation, and Loading) tools. Since the data generated by customers is not in the format required by DW, it needs to be processed in the transformation layer of ETL. This processing will involve the enriching of transactions data with information from Master Data (MD) as shown in Figure 2
Attachments:
5597220_1_assessment-1.pdf