Oracle 1z0-1094-23 Exam Practice Questions (P. 5)

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?

You are asked to isolate all the erroneous rows into error tables before they get into the target tables, in order to have a list of corrections that need to be addressed before the next run.
At the next run, the demand is to check whether there are some rows that have been fixed and automatically include them in the integration flow.
Which two conditions need to be met to accomplish this demand in Oracle Data Integrator (ODI)? (Choose two.)

You are planning the migration of a 19c Oracle Database from Amazon Web Services Relational Database Service (AWS RDS) using RMAN backups.
What is the correct sequence of operations?

What can you use to quickly load data into a cloud database by dragging and dropping a file in a web browser?