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

A. Create a single Mapping with two Physical Designs: one for theinitialload and one for the incremental updates.

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

C. Create two Mappings: one for the initial load and one for the incremental updates. Duplicate the transformation logic.

D. Create a single Mapping and use variables in the Logical Design to do an initial load when required or an incremental update otherwise.

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

A. The project must be explicitly mapped within an ODI mapping.

B. A customize knowledge module is needed.

C. An ODI procedure must be associated with it.

D. It can be defined for every technology listed in the topology.

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

A. It enables developers to execute most ODI operations through a Java program.

B. It can be used to embed ODI processes into another product.

C. It is used to load data between Teradata and Oracle.

D. It must be used by ETL developers to develop ODI processes.

You want to modify the code generated by a failed Task and restart the session. How must you proceed? (Choose the best answer.)

A. Open the Task in Operator, go to Code, click Edit, use Pre-execution Code to edit the code, and save it.

B. It is not possible to modify the code once it has been generated.

C. Open the Step in Operator, edit the code, and save it.

D. Open the Task in Operator, go to Code, click Query/Execution Plan to edit the code, and save it.

Identify three capabilities of load plans. (Choose three.)

A. restart from failed tasks

B. exception handling

C. native support for parallelism

D. support for Open Tools

E. restart of an agent

How are the domains of ODI Agents configured? (Choose the best answer.)

A. by using Upgrade Assistant

B. by using ODI Studio

C. by using Domain Creation Assistant

D. by using Configuration Wizard

You must ensure that your Mappings do not run into connectivity issues when moving data from server A to server B by using an AGT agent that is running on server B.

How must you test this by using ODI Studio running on machine C? (Choose the best answer.)

A. UseOdiPingAgentin a package to ping AGT agent.

B. In Topology, test the connections to servers A and B by using the AGT agent.

C. In Topology, test the connections to the AGT agent.

D. In Topology, test the connections to servers A and B by using Local (No Agent).

The workflow you are designing requires checking to see whether there are records available in a source table before doing anything.

Which ODI tool must you use to implement this? (Choose the best answer.)

A. OdiWaitForData

B. OdiWaitForCDCData

C. OdiWaitForLogData

D. OdiWaitForTable

Identify the ODI tool used to write content into a file in a package. (Choose the best answer.)

A. OdiOutFile

B. OdiFileCopy

C. OdiFileMove

D. OdiInFile

Which statement is correct about all expressions in a Mapping? (Choose the best answer.)

A. It is possible to set the execution location on source, staging area, or target.

B. All transformations are executed on the staging area.

C. Only the source and target servers can be used to execute expressions.

D. All expressions are executed on the source area.