Oracle Cloud Infrastructure 2023 AI Foundations Associate — Question 32
Your source tables are in an on-premises Oracle Database. You have created the data server and logical schema in an Oracle Data Integrator (ODI) topology.
Now you are ready to start reverse engineering and create mappings.
Which two Knowledge Modules (KM) need to be imported to your project for the Oracle Database source? (Choose two.)
Answer options
- A. LKM SQL to MSSQL
- B. IKM XML Control Append
- C. RKM Oracle
- D. CKM HSQL
- E. LKM SQL to Oracle
Correct answer: C, E
Explanation
The correct Knowledge Modules for working with an Oracle Database source in ODI are RKM Oracle (C) and LKM SQL to Oracle (E). RKM Oracle is essential for reverse engineering Oracle data, while LKM SQL to Oracle is necessary for loading data from other sources into Oracle. The other options are not applicable for Oracle as they pertain to different database systems or contexts.