Oracle Data Integrator Set 1

1.

How does the data flow when moving records between two servers by using Database Links and an Agent installed on a middle-tier server? (Choose the best
answer.)

from the source database into flat files that are then loaded into the target database directly from the source database to the target database from the source database onto the server running the Agent and then into the target database from the source database into the machine running ODI Studio and then into the target database

2.

You are a project developer using ODI and want to consolidate your own local metadata repositories. Identify the true statement. (Choose the best answer.)

You must consolidate your own local metadata repositories. The local metadata must be transmitted via ftp and synchronized with a dedicated proprietary engine, creating a common metadata model for all the developers. You must consolidate your own local metadata repositories. You have to invoke a dedicated web service to synchronize the metadata by using Oracle Service
Bus. You need not consolidate your own local metadata repositories, because the ODI proprietary metadata server allows all developers to share the common
metadata of a specific project. You need not consolidate your own local metadata repositories, because ODI uses a centralized relational metadata repository that all the developers share.

3.

How should you define the Work Schema of a Physical Schema? (Choose the best answer.)

Use a dedicated schema such as ODI_STAGING.

Use TEMP. Use the same schema as the Data Schema. Use SYSTEM.

4.

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.

5.

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

6.

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.

7.

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

ERR$

ERROR$

ODI_ERR$

E$

8.

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.

9.

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.

10.

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.

Oracle Data Integrator Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

COMPANY

Products

OTHERS

Partner

Oracle Data Integrator Set 1

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Answer & Solution

Answer: Option B

Solution:

Congratulations

Detail Form

COMPANY

Products

OTHERS

Partner