Oracle Cloud Infrastructure 2023 AI Foundations Associate — Question 4

You are asked to isolate all the erroneous rows into error tables before they get into the target tables, in order to have a list of corrections that need to be addressed before the next run.
At the next run, the demand is to check whether there are some rows that have been fixed and automatically include them in the integration flow.
Which two conditions need to be met to accomplish this demand in Oracle Data Integrator (ODI)? (Choose two.)

Answer options

• A. You must have an update key on the target table.
• B. The Check Knowledge Module must have the RECYCLE_ERRORS option set to TRUE.
• C. The static control has to be enabled and the RECYCLE_ERRORS option set to TRUE.
• D. The flow control has to be enabled and the RECYCLE_ERRORS option set to TRUE.
• E. You must have a primary key on the target table.

Correct answer: B, D

Explanation

The correct answers are B and D because the RECYCLE_ERRORS option must be enabled in conjunction with flow control to allow corrected rows to be reintegrated into the flow. Options A and E are not relevant to the requirement of recycling errors, and options C does not address the specific need for flow control.