When Oracle Data Integrator (ODI) and Oracle GoldenGate are used together, which option represents the phases of an ELT process that Oracle GoldenGate performs? (Choose the best answer.)

• A. transform only
• B. extract and transform
• C. load and transform
• D. extract and load

You want to ensure that the Physical Mapping Design cannot be modified even if the Logical Design of the Mapping is changed. What sequence of steps must you follow to achieve this? (Choose the best answer)

• A. Go to the Physical tab, deselect theModify check boxof the Physical Mapping Design.
• B. Go to the Physical tab, select the Is Frozen check box of the Physical Mapping Design.
• C. Go to the Physical tab, select the Read-only check box of the Physical Mapping Design.
• D. Go to the Physical tab, select theFixedDesign check boxof the Physical Mapping Design.

Which statement is correct about choosing the join order in an ODI Mapping when defining a join? (Choose the best answer.)

• A. This option is always available.
• B. This option is inherited from reverse engineering.
• C. You can never make this choice.
• D. This option may be available only if the underlying technology supports it.

Your project requires a loop through the same package logic 24/7. You must be able to purge those executions when required. How do you accomplish this? (Choose the best answer.)

• A. Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save and regenerate this scenario.
• B. Drag the package to the last step in the package, run it asynchronously, and then save.
• C. Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save.
• D. Link the last step of the package to its first step to create an infinite loop.

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? (Choose the best answer.)

• A. Create a procedure. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Commandon Targetthat usesOdiSendMailto send the email using the bind variable defined in the Command on Source.
• B. Create a procedure and add two tasks. The first one must have a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and the second must have a Command on Target that usesOdiSendMailto send the email by using the bind variable defined in the first task.
• C. Create a counter variable that gets the total number of email addresses stored in the database table. Next, create another variable that selects the email addresses from the database table. Then, create a loop in the packages by using the variables and anOdiSendMailstep.
• D. Createa Knowledge Module. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Command on Target that usesOdiSendMailto send the email using the bind variable defined in the Command on Source.