During which ETL phase might you apply data cleansing operations, such as removing duplicates or correcting data inconsistencies?
- Extraction
- Loading
- Reporting
- Transformation
Data cleansing operations, like removing duplicates and correcting data inconsistencies, are typically performed during the Transformation phase of the ETL process. This is when data is prepared for storage in the data warehouse and is where data quality improvements are made.
Loading...
Related Quiz
- How does a "risk matrix" aid in the IT risk management process?
- In a top-down approach to building a data infrastructure, which is typically built first?
- What potential disadvantage can arise from excessive denormalization of a database?
- How does the snowflake schema differ from the star schema in terms of its structure?
- For interactive dashboards, which feature allows users to focus on specific parts of the data by filtering out other sections?