Exam 1z0-1094-23 All QuestionsBrowse all questions from this exam
Question 22

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.)

    Correct Answer: D, E

    To isolate erroneous rows and reinclude them once fixed in Oracle Data Integrator, two conditions must be met. First, the flow control has to be enabled and the RECYCLE_ERRORS option set to TRUE, which ensures that rows flagged as errors are isolated and later checked for corrections. Second, having a primary key on the target table is crucial for uniquely identifying and updating rows, especially once erroneous rows have been corrected and are ready to be reprocessed.

Discussion
piipoOptions: DE

D and E

ReneScOptions: DE

Should be D, E. CKM does not have the given option

geddeOptions: DE

D and E

SirGioOptions: AD

Should be A, D according to 7.5 Data Quality section in the course.