Interested to Buy Any Domain ? << Click Here >> for more details...
Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?
- 1 Answers
- 29 Views
- I also Faced
- E-Mail Answers
Answer Posted / Jay Vardhan Hemant
{"error handling techniques": "Error handling is crucial in ETL processes to ensure data quality. Common techniques include: 1) Ignoring errors by continuing with the next record. This can be useful when dealing with minor issues, but it may result in corrupt data if not used carefully.","2) Rejecting bad records and writing them to a flat file for later review. This allows you to identify and correct errors manually. 3) Loading the records and applying default values for missing or invalid data. This can be useful when dealing with minor inconsistencies, but it may result in loss of original data if not used carefully."
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
