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
- 31 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
I am new to sas, can anybody explain the process of extracting data from source systems,storing in ods and how data modelling is done?
Techniques of error handling - ignore, rejecting bad records to a flat file, loading the records and reviewing them (default values)?
What are materialized views & where do we use them? What is a materialized view log?
What are snapshots? What are materialized views & where do we use them? What is a materialized view?
What are materialized views & where do we use them? What is a materialized view?
Where do we use connected and un connected lookups?
Can we look-up a table from source qualifier transformation. Ie. Unconnected lookup?
When do you analyze the tables?
What is the purpose of a staging area?
What are active transformation / passive transformations?
What is a staging area? Do we need it?
What are the various tools? - Name a few?
Oracle General 
