Weekend Sale - Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: sntaclus

examout.co

What is the main benefit of using consistent set journalizing compared to simple journalizing? (Choose the best answer.)

A.

Consistent set journalizing runs faster than simple journalizing.

B.

Consistent set journalizing always uses Oracle GoldenGate.

C.

Consistent set journalizing treats each data store individually.

D.

Consistent set journalizing provides a guarantee of consistency of the captured changes.

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

A.

from the source database into flat files that are then loaded into the target database

B.

directly from the source database to the target database

C.

from the source database onto the server running the Agent and then into the target database

D.

from the source database into the machine running ODI Studio and then into the target database

Which statement is true about defining more than one physical schema associated to the same data server? (Choose the best answer.)

A.

ODI topology does not allow defining more than one physical schema for a data server; the associated logical schema would be ambiguous.

B.

It is possible to define more than one physical schema associated to the same data server, but it is mandatory to specify a different user to log in.

C.

It is possible to define more than one physical schema associated to the same data server, but you must flag the default physical schema.

D.

It is possible but it is better to avoid doing so because it is more difficult to define a logical schema this way.

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.

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.

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

Which two objects can be dragged to a Mapping? (Choose two.)

A.

Variables

B.

Datastores

C.

Knowledge Modules

D.

Reusable Mappings

You want to draw directly in the data flow all the details about how the different servers involved are connected, in order to load a specific table by using ODI.

What must you do to accomplish this? (Choose the best answer.)

A.

In the ODI Interface palette, choose the more convenient graphic objects to link the involved servers.

B.

You need not draw directly in the data flow all the details about how the different servers involved are connected. ODI automatically designs the flow and how servers are connected.

C.

You need not draw directly in the data flow all the details about how the different servers involved are connected. The code will be the black box generated directly by ODI.

D.

You must draw directly in the data flow all the details about how the different servers involved are connected, and also specify with variables the passwords for connecting to the data contained in the servers.

In a Mapping, you want to load the data by using a specific partition that is declared for a target table. Which statement is correct in this situation? (Choose the best answer)

A.

It is not possible to use a specific partition.

B.

Only ODI variables can be used to filter the target table loading.

C.

An option in the Mapping can be used to declare partitions but an ODI variable must be used to evaluate the correct partition value.

D.

An option in the Mapping can be used to declare the partition that has to be used for the loading.

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.