Oracle Exam 1Z0-1094-23 Topic 1 Question 1 Discussion

Actual exam question for Oracle's 1Z0-1094-23 exam

Question #: 1
Topic #: 1

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

AYou must have an update key on the target table.

BThe Check Knowledge Module must have the RECYCLE ERRORS option set to TRUE.

CThe static control has to be enabled and the RECYCLE ERRORS option set to TRUE.

DThe flow control has to be enabled and the RECYCLE ERRORS option set to TRUE.

EYou must have a primary key on the target table.

Show Suggested Answer

Suggested Answer: D, E

In Oracle Data Integrator (ODI), to isolate erroneous rows and recycle corrected rows in subsequent runs, flow control must be enabled with the RECYCLE ERRORS option set to TRUE. Additionally, having a primary key on the target table is essential for identifying and managing rows during the integration process, ensuring data integrity and facilitating error handling.

by Levi at Feb 09, 2024, 11:33 AM

Limited Time Offer

25%

7 months ago

I think the correct options are A) and B).

upvoted 0 times

...