Free Oracle 1z1-448 Exam Dumps Questions & Answers

You want to draw directly in the data flow all the details about how the different servers involved are connected, in order to load a specific table by using ODI.
What must you do to accomplish this? (Choose the best answer.)

• A.In the ODI Interface palette, choose the more convenient graphic objects to link the involved servers.
• B.You need not draw directly in the data flow all the details about how the different servers involved are connected. ODI automatically designs the flow and how servers are connected.
• C.You need not draw directly in the data flow all the details about how the different servers involved are connected. The code will be the black box generated directly by ODI.
• D.You must draw directly in the data flow all the details about how the different servers involved are connected, and also specify with variables the passwords for connecting to the data contained in the servers.

Which two statements are true about the Oracle Data Integrator Software Development Kit (ODI SDK)? (Choose two.)

• A.It must be used by ETL developers to develop ODI processes.
• B.It can be used to embed ODI processes into another product.
• C.It is used to load data between Teradata and Oracle.
• D.It enables developers to execute most ODI operations through a Java program.

Identify the ODI tool used to write content into a file in a package. (Choose the best answer.)

• A.OdiFileCopy
• B.OdiOutFile
• C.OdiFileMove
• D.OdiInFile

Identify two constraints that can be used to ensure uniqueness in ODI. (Choose two.)

• A.alternate keys
• B.not null
• C.primary keys
• D.conditions
• E.foreign keys

You must run the same mapping concurrently while avoiding clashes of ODI temporary objects. How must you implement this? (Choose the best answer.)

• A.Create a custom Knowledge Module (KM) to handle this by using ODI variables to create unique temporary object names.
• B.Select the Use Unique Temporary Object Names check box at the Physical Design level.
• C.Create a custom KM to handle this by using ODI variables defined at the Topology level to create unique temporary object names.
• D.Use variables in the Logical Design of the Mapping to create unique temporary object names.