Which statement is true about the IKM SQL Control Append that creates an intermediate integration table prefixed with I$? (Choose the best answer.)
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.
Explanation:
(http://www.oracle.com/us/products/middleware/data-integration/odi-performance-guide-wp-2147067.pdf)
D
quiz-1z0-448/ has only 46 questions
What about the rest ?
Answer: B
Explanation: https://docs.oracle.com/middleware/1213/odi/develop-km/ikm.htm#ODIKD975
(The same integration strategy can be obtained by using the Control Append strategy and not choosing to activate flow control.)
B
IKM then writes the result set directly into target table (in case of “Append” integration mode) and into an Integration table “I$” (in case of more complex integration mode. For e.g., Incremental Update, SCD) before loading into target.
Answer B:
https://docs.oracle.com/middleware/1212/odi/ODIKD/intro.htm#ODIKD872
From this link:
Simple “append” IKMs directly write this result set into the target table. More complex IKMs create an “I$” table to store this result set.
B
IKM loads the records from “I$” table to target table using the defined integration mode (control append, Incremental update, etc.)