Multiple choice technology databases

Data Cleansing is mainly done at which phase of Data Warehouse Development

  1. Extract

  2. Transform

  3. Load

  4. None of the Above
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

Data cleansing occurs primarily during the Transform phase of ETL (Extract, Transform, Load). During transformation, data is cleaned, validated, standardized, and corrected before being loaded into the data warehouse. The Extract phase only retrieves data, and the Load phase writes already-cleaned data to the target system.

Keep practicing — related questions