Oracle Global Human Resources Cloud Payroll Implementation Specialist — Question 18

Which statement is true about the IKM SQL Control Append that creates an intermediate integration table prefixed with I$? (Choose the best answer.)

Answer options

• A. The intermediate integration table prefixed with I$ is required to determine which records must be inserted.
• B. If Flow Control is not necessary, an I$ table is not created.
• C. The intermediate integration table prefixed with I$ is created because the flow control is mandatory when doing an initial load.
• D. Neither the LKM nor the IKM create intermediate tables. Most of their work is performed in the ODI Agent memory.

Correct answer: D

Explanation

The correct answer is D because neither the LKM nor the IKM generates intermediate tables, as they handle most operations in the memory of the ODI Agent. Options A, B, and C incorrectly imply that an I$ table is created or required under certain conditions, which is not the case.