Question 1

Which two statements are true about using ODI and Oracle GoldenGate together? (Choose two.)

Options :

A : Oracle GoldenGate primarily performs aggregations for ODI.

B : Oracle GoldenGate and ODI are used together primarily for running weekly batch jobs.

C : Oracle GoldenGate provides non-invasive changed data capture capabilities to ODI.

D : ODI starts and stops Oracle GoldenGate processes automatically during a Mapping execution.

E : ODI and Oracle GoldenGate enable real-time business intelligence.

Answer: A,E

Question 2

Identify two constraints that can be used to ensure uniqueness in ODI. (Choose two.)

Options :

A : conditions

B : foreign keys

C : primary keys

D : alternate keys

E : not null

Answer: B,E

Question 3

How would a Knowledge Module, that is required to perform an aggregation in a Mapping, generate the correct code? (Choose the best answer.)

Options :

A : The Knowledge Module must be customized because business rules and the physical implementation are strictly interlayed in ODI.

B : The Knowledge Module must be customized only for aggregation functions.

C : The Knowledge Module need not be customized because aggregation code is generated automatically by ODI according to the Mapping logic.

D : The Knowledge Module need not be customized, but a variable must be used in the aggregate expression to generate the correct sum.

Answer: D

Question 4

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

Options :

A : Create a custom KM to handle this by using ODI variables defined at the Topology level to create unique temporary object names.

B : Use variables in the Logical Design of the Mapping to create unique temporary object names.

C : Create a custom Knowledge Module (KM) to handle this by using ODI variables to create unique temporary object names.

D : Select the Use Unique Temporary Object Names check box at the Physical Design level.

Answer: D

Question 5

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

Options :

A : Variables

B : Datastores

C : Knowledge Modules

D : Reusable Mappings

Answer: B,D