Answer:
Step-by-step explanation:
almost all databases like SQL, Oracle or data warehouses use ETL (Extract, Transform and Load) procedure to extract data from multiple sources, transform them and then load into their own databases.
use of error event schema during an ETL process is
undoubtedly the best option to do the complete procedure error free
it gives you guarantee to handle all the data lapses like data duplication, missing data values, invalid values etc. etc.
thus, to minimize the time and maximize the quality it is highly recommended to use error event schema during an ETL process.