Examice

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

Question 21

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?

The Check Knowledge Module was not set in the physical design.

There were no rows compliant with the imposed constraint.

The integration type was not set in the logical design.

A primary key was not defined on the target table.

Correct Answer: A

The reason for the error is that the Check Knowledge Module (CKM) was not set in the physical design. When integrating data with flow control enabled, ODI requires the CKM to be specified. The CKM contains the necessary logic to perform data validation and constraints checks. Without it, ODI cannot perform these checks, causing an error at compile time.

Discussion

GiorgioGssOption: A

"If the CKM is not set in the physical design, ODI will not be able to perform these checks, leading to an error at compile time."