Odi_Examen_Repasar_Cambios

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 the initial load 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.

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

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.

Which two statements are true about ODI web-based components? (Choose two.)

A. ODI Console allows administrators to edit users’ information.
B. Enterprise Manager Cloud Control provides access to ODI data servers’ settings.
C. ODI sessions can be monitored in Enterprise Manager Cloud Control.
D. ODI Console provides access to project and mapping details.

You must send the same message in multiple packages to several email addresses stored in the same database table. How do you accomplish this by using a reusable package step?

A. Create a procedure and add two tasks.

B. Create a Knowledge Module.

C. Create a counter variable that gets the total number of email addresses stored in the database table

D. Create a procedure.

Identify two benefits that are unique to ODI JEE Agents. (Choose two.)

A. high availability
B. minimal footprint
C. access to WebLogic connection pools
D. management in Enterprise Manager Cloud Control