ODI Quiz on Mappings and Strategies

You need to implement security mechanisms that allow only user ''A'' to view all the Mappings contained in a specific project named ''P1.'' How must you proceed?

• Go to Security, assign the NG DESIGNER profile to user ''A.'' Next, drag project ''P1'' to user ''A'' and finally set View privileges to Active for the Mapping objects.

• Go to Security, assign the DESIGNER profile to user ''A.'' Next, drag project ''P1'' to user ''A'' and finally set View privileges to Active for the Mapping objects.

• Go to Security, assign the NG DESIGNER profile to user ''A.'' Next, drag project ''P1'' to user ''A'' and finally set View privileges to Active for the Project, Folder, and Mapping objects.

• Go to Security, assign the DESIGNER profile to user ''A.'' Next, drag project ''P1'' to user ''A'' and finally set View privileges to Active for the Project, Folder, and Mapping objects.

How can you define the order in which target data stores are loaded in a Mapping?

• ODI automatically computes the load order based on the order on which the data stores were added to the Mapping.

• You can use the Target Order field.

• You can use the Target Load Order field.

• You can use the Load Order field.

Identify the correct variable step type to use when assigning a value to a variable with an SQL query.

• Evaluate Variable

• Set Variable

• Declare Variable

• Refresh Variable

You need to create a Model that works with multiple underlying technologies. How must you proceed?

• This works only for Oracle and Informix.

• This works only for Oracle and MySQL.

• Create a new generic technology to support it.

• Use the out-of-the box Generic SQL technology.

How would a Knowledge Module, that is required to perform an aggregation in a Mapping, generate the correct code?

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

• The Knowledge Module must be customized only for aggregation functions.

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

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

Identify two implementation strategies of changed data capture provided through ODI Knowledge Modules. (Choose two.)

• extracting source data to flat files

• triggers

• Oracle GoldenGate

• before-and-after database image comparison

How does the data flow when moving records between two servers by using Database Links and an Agent installed on a middle-tier server?

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

• directly from the source database to the target database

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

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

You are a project developer using ODI and want to consolidate your own local metadata repositories. Identify the true statement.

• You must consolidate your own local metadata repositories. The local metadata must be transmitted via ftp and synchronized with a dedicated proprietary engine, creating a common metadata model for all the developers.

• You must consolidate your own local metadata repositories. You have to invoke a dedicated web service to synchronize the metadata by using Oracle Service Bus.

• You need not consolidate your own local metadata repositories, because the ODI proprietary metadata server allows all developers to share the common metadata of a specific project.

• You need not consolidate your own local metadata repositories, because ODI uses a centralized relational metadata repository that all the developers share.

How should you define the Work Schema of a Physical Schema?

• Use a dedicated schema such as ODI_STAGING.

• Use TEMP.

• Use the same schema as the Data Schema.

• Use SYSTEM.

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?

• Create a single Mapping with two Physical Designs: one for the initial load and one for the incremental updates.

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

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

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