Oracle Cloud Infrastructure 2023 AI Foundations Associate — Question 25

When integrating data from multiple sources into a Data Warehouse schema, you want to check a length constraint that you have imposed on one of the target columns before the rows arrive in the target table.
All the rows that do not pass this quality check will have to be isolated in error tables.
For this, you have chosen an Integration Knowledge Module (IKM) that supports flow control. You have also chosen the value TRUE for this parameter to enable this check.
At compile time, you see that Oracle Data Integrator (ODI) throws an error and the execution cannot start.
What is the reason?

Answer options

• A. The Check Knowledge Module was not set in the physical design.
• B. There were no rows compliant with the imposed constraint.
• C. The integration type was not set in the logical design.
• D. A primary key was not defined on the target table.

Correct answer: D

Explanation

The correct answer is D because a primary key is essential for the target table in order to enforce data integrity and uniqueness constraints. Without a primary key, the ODI cannot properly manage the flow of data and validate the constraints, leading to compilation errors. The other options do not address the fundamental requirement of having a primary key in place to proceed with the integration process.