1Z0-448 Free Practice Test

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

1. A. Theintermediate integration table prefixed with I$is required to determine which records must be inserte
2. B. IfFlow Control is not necessary, an I$ table is not create
3. C. Theintermediate integration table prefixed with I$ is createdbecause the flow control is mandatory when doing an initial loa
4. D. Neither the LKM northe IKM create intermediate table
5. E. Most of their work is performed in the ODI Agent memor

Correct Answer: D
(http://www.oracle.com/us/products/middleware/data-integration/odi-performance-guide-wp-2147067.pdf)

You are working with delimited flat files and want to enforce a primary key on a flat file by using a Check Knowledge Modules (CKM). However, you encounter an error.
Why did this happen?(Choose the best answer.)

1. A. It is not possible to enforce constraints on some technologies such as flat files and Java Messaging Service (JMS) querie
2. B. It is not possible to enforce constraints on any technolog
3. C. It is only possible to forward-engineer it to the flat file definitio
4. D. It is possible to enforce a primary key on a flat file by using a CKM; however, you have to save it as a fixed fil

Correct Answer: D
(http://www.oracle.com/technetwork/middleware/data-integrator/learnmore/odi-best-practice-data-warehouse-168255.pdf)