Oracle
1Z0-448 · Question #2
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…
The correct answer is B. Only the latest entry is processed based on the JRN_DATE field. See the full explanation below for the reasoning.
Question
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.)
Options
- AAll distinct entries are processed.
- BOnly the latest entry is processed based on the JRN_DATE field.
- COnly the first entry is processed based on the JRN_DATE field.
- DA PK violation occurs due to the duplicated entries and the entries are inserted in the E$ table.
How the community answered
(45 responses)- A9% (4)
- B73% (33)
- C13% (6)
- D4% (2)
Community Discussion
No community discussion yet for this question.