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

1z0-1094-23 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.)

Show Answer
Correct Answer: BDE

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

4 comments
Sign in to comment
ReneScOptions: DE
Mar 15, 2024

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

piipoOptions: DE
May 24, 2024

D and E

SirGioOptions: AD
Mar 25, 2024

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

geddeOptions: DE
Apr 18, 2024

D and E