Examice

Exam 1z0-1094-23 All QuestionsBrowse all questions from this exam

Question 13

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?

You can join table A and table B, as required by the data model and load target C in a single mapping.

A mapping can have only one source and one target. You need to create 2 mappings to load target C.

You are required to do outer join between table A and table B in order to load target C.

You are required to do inner join between table A and table B in order to load target C.

Correct Answer: A

In Oracle Data Integrator (ODI), it is possible to join multiple source tables and map them to a single target table within a single mapping. This allows users to combine data from table A and table B as required by the data model and load into the denormalized target table C efficiently. Therefore, the correct statement is that you can join table A and table B, as required by the data model and load target C in a single mapping.

Discussion

piipoOption: A

Collect