QUESTION: 5

You have been tasked with designing a Mapping that must perform an initial load and incremental updates using the same transformation logic. How should you proceed? (Choose the best answer.)

Create a single Mapping with two Physical Designs: one for the initial load and one for the incremental updates.
Create a single Mapping with a single Physical Design and modify it appropriately when an initial load is required or when an incremental update is required.
Create two Mappings: one for the initial load and one for the incremental updates. Duplicate the transformation logic.
Create a single Mapping and use variables in the Logical Design to do an initial load when required or an incremental update otherwise.

Answer(s): D

Reference:

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

Show Answer Next Question

QUESTION: 6

How are the ODI repositories upgraded? (Choose the best answer.)

by using Opatch
by using ODI Studio
by using the import/export utilities
by using Upgrade Assistant

Answer(s): A

Reference:

(http://odibeginnertutorials.blogspot.in/2013/12/odi-12c-installation-and-odi-12c.html)

Show Answer Next Question

QUESTION: 7

You must run the same mapping concurrently while avoiding clashes of ODI temporary objects. How must you implement this? (Choose the best answer.)

Create a custom KM to handle this by using ODI variables defined at the Topology level to create unique temporary object names.
Use variables in the Logical Design of the Mapping to create unique temporary object names.
Create a custom Knowledge Module (KM) to handle this by using ODI variables to create unique temporary object names.
Select the Use Unique Temporary Object Names check box at the Physical Design level.

Answer(s): D

Reference:

(https://blogs.oracle.com/dataintegration/entry/odi_12c_parallel_target_table)

Show Answer Next Question

QUESTION: 8

Which tables created by ODI contain error records? (Choose the best answer.)

ERR$
ERROR$
ODI_ERR$
E$

Answer(s): D

Reference:

(https://docs.oracle.com/middleware/1212/odi/ODIKD/ckm.htm#ODIKD925)

Show Answer Next Question

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

QUESTION: 5

Reference:

QUESTION: 6

Reference:

QUESTION: 7

Reference:

QUESTION: 8

Reference:

1z0-448 Exam Discussions & Posts