Oracle Cloud Infrastructure 2023 AI Foundations Associate — Question 17

You are trying to load a denormalized target table C and the source attributes come from table A and Table B in Oracle Data Integrator (ODI).
Which statement is true?

Answer options

• A. You can join table A and table B, as required by the data model and load target C in a single mapping.
• B. A mapping can have only one source and one target. You need to create 2 mappings to load target C.
• C. You are required to do outer join between table A and table B in order to load target C.
• D. You are required to do inner join between table A and table B in order to load target C.

Correct answer: A

Explanation

The correct answer is A because it is possible to join table A and table B together in a single mapping to load target table C, following the data model's requirements. Options B, C, and D are incorrect because they either impose unnecessary restrictions on the mapping process or specify incorrect join types that are not mandated for this scenario.