Exam 1z0-1094-23 topic 1 question 21 discussion

Actual exam question from Oracle's 1z0-1094-23

Question #: 21
Topic #: 1

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?

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.

Show Suggested Answer

Suggested Answer: D 🗳️

by GiorgioGss at July 4, 2024, 7:44 p.m.

Comments

Submit Cancel

GiorgioGss

5 months, 3 weeks ago

Selected Answer: 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."

upvoted 1 times

...

Exam 1z0-1094-23 All Questions

View all questions & answers for the 1z0-1094-23 exam

Exam 1z0-1094-23 topic 1 question 21 discussion

Comments

GiorgioGss

SY0-701