During a data migration project, a data quality issue is identified in the source system. What transformation strategy should be applied to clean and standardize this data?
- Apply cleansing rules and transformations to correct data issues
- Bypass the data quality issue and load the data as-is
- Implement data profiling and analysis to identify patterns
- Reject and log the erroneous records for manual correction
In the case of a data quality issue during migration, the recommended strategy is to apply cleansing rules and transformations to correct the data issues. This ensures that the data meets the required quality standards before being loaded into the target system.
Loading...
Related Quiz
- After a major ETL update, several unexpected defects arise. What steps should be taken to ensure these are reported and addressed effectively?
- ________ in a Data Warehouse helps in maintaining the history of data changes over time.
- In ETL testing, the use of __________ can significantly reduce the risk of data corruption during transformation.
- Which phase in the Test Execution Lifecycle involves the actual execution of test cases?
- What are the implications of using real-time data warehousing?