During the ETL process, the "Transform" phase involves data ____________ to make it suitable for the target system.
- Cleansing
- Extraction
- Validation
- Manipulation
The "Transform" phase in ETL (Extract, Transform, Load) involves manipulating data to ensure it aligns with the structure and requirements of the target system. This can include tasks such as data cleansing, enrichment, aggregation, and normalization. Thus, the correct option is "Manipulation."
Loading...
Related Quiz
- Which SQL statement allows you to roll back a transaction in the event of an error?
- You are tasked with improving the performance of a reporting database that stores historical sales data. The reports involve complex aggregations and filtering. How would you use indexing to optimize the data retrieval speed for such reports?
- In SQL, what is the role of the "TRY...CATCH" block in error handling?
- Scenario: An organization's database contains highly confidential employee data. Access control testing reveals that unauthorized employees can view this data. What access control measure should be implemented to address this issue?
- Access control testing should include evaluating the effectiveness of ____________ controls to prevent unauthorized access.