Discussions
Respond to the following in 200 words or less APA format. Please cite work.
Q1 - ETL Processing
Define and provide examples of the cleansing, conforming, and transforming steps in the ETL process.
Q2 - ETL System Components
Discuss the components of an ETL system. What are the pros and cons of building a custom ETL tool.
Q3 - Source System Data Issues
Give three examples of problems likely to be found when operational data are integrated into the data warehouse. How can each of these problems be mitigated in the ETL process? How would you correct bad data in the warehouse?