QUESTION: 9

Your customer wants a project in ODI, which contains a user function, to translate commands with different syntax for different technologies but with the same functionality.
How can you achieve this? (Choose the best answer.)

The project must be explicitly mapped within an ODI mapping.
A customize knowledge module is needed.
An ODI procedure must be associated with it.
It can be defined for every technology listed in the topology.

Answer(s): D

Reference:

(http://docs.oracle.com/cd/E23943_01/integrate.1111/e12643/procedures.htm#ODIDG464)

Show Answer Next Question

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.)

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

Answer(s): B

Reference:

(http://www.ateam-oracle.com/understanding-the-odi-jkms-and-how-they-work-with-oracle-goldengate/)

Show Answer Next Question

QUESTION: 11

You want to ensure that the Physical Mapping Design cannot be modified even if the Logical Design of the Mapping is changed. What sequence of steps must you follow to achieve this? (Choose the best answer)

Go to the Physical tab, select the Fixed Design check box of the Physical Mapping Design.
Go to the Physical tab, select the Is Frozen check box of the Physical Mapping Design.
Go to the Physical tab, select the Read-only check box of the Physical Mapping Design.
Go to the Physical tab, deselect the Modify check box of the Physical Mapping Design.

Answer(s): C

Reference:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1560)

Show Answer Next Question

QUESTION: 12

Which two statements are true about the Oracle Data Integrator Software Development Kit (ODI SDK)? (Choose two.)

It enables developers to execute most ODI operations through a Java program.
It can be used to embed ODI processes into another product.
It is used to load data between Teradata and Oracle.
It must be used by ETL developers to develop ODI processes.

Answer(s): A,D

Reference:

(https://foursconsultancy.wordpress.com/odi/oracle-data-integrator-12c-components/)

Show Answer Next Question

Free Oracle 1z0-448 Exam Questions (page: 4)

QUESTION: 9

Reference:

QUESTION: 10

Reference:

QUESTION: 11

Reference:

QUESTION: 12

Reference:

1z0-448 Exam Discussions & Posts