Discussions

Q1)  ETL stands for Extract, Transformation and Load. This is an important process in the Data Warehouse environment. Since data flows from the source databases and other sources. Why is it important to transform the data from the source format into the Data Warehouse format? 

Q2)  Part of the transformation process is cleansing data. Discuss what is meant my data cleansing and why this is important to have cleansed data in the Data Warehouse.