Question 1

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 2

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

Options :

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.

Answer: D

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

Identify two correct statements about reusable Mappings. (Choose two.)

Options :

A : They can have generic input and output signatures.

B : They contain both a Logical and Physical Mapping design.

C : They can be used within regular Mappings.

D : They can be executed directly.

E : They can be shared across projects.

Answer: A,B

Question 5

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