Question 1

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 2

You create two mappings that both use the same changed data and run at different times. One runs every 15 minutes and the other runs once every day. What must you do to ensure that the Mapping that gets executed more often does not consume the changed data required by the other Mapping? (Choose the best answer.)

Options :

A :

Use Consistent CDC, do not perform a purge of the journal data when the first Mapping gets executed, and manually change the JRN_SUBSCRIBER column in the corresponding J$ table to keep the changed data present for the second Mapping.

B :

Create a third mapping to copy the changed data to a staging table, which is used as the source of the second Mapping.

C : Duplicate the source data store for each Mapping.

D : Create two distinct subscribers for each Mapping.

Answer: A

Question 3

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

Confidently Practice Online with Free 1Z0-448 Exam Cram

Buying Options: