ExamQuestions.com

Register
Login
Oracle Data Integrator 12c Essentials Exam Questions

Oracle

Oracle Data Integrator 12c Essentials

10 / 44

Question 10:

If multiple changes occur on the source system but have not yet been processed by ODI, the J$ table contains entries for each change for the records sharing the same PK. What happens at run time when a Mapping gets executed? (Choose the best answer.) 

Answer options:

A. All distinct entries are processed.
B. Only the latest entry is processed based on the JRN_DATE field.
C. Only the first entry is processed based on the JRN_DATE field.
D. A PK violation occurs due to the duplicated entries and the entries are inserted in the E$ table.