Oracle Data Integrator 12c Essentials - 1z0-448 Exam Practice Test

A. It is not possible to use a specific partition.

B. An option in the Mapping can be used to declare partitions but an ODI variable must be used to evaluate the correct partition value.

C. Only ODI variables can be used to filter the target table loading.

D. An option in the Mapping can be used to declare the partition that has to be used for the loading.

A. You must consolidate your own local metadata repositories. You have to invoke a dedicated web service to synchronize the metadata by using Oracle Service Bus.

B. You need not consolidate yourown local metadata repositories, because ODI uses a centralized relational metadata repository that all the developers share.

C. You must consolidate your own local metadata repositories. The local metadata must be transmitted via ftp and synchronized with a dedicated proprietary engine, creating a common metadata model for all the developers.

D. You need not consolidate your own local metadata repositories, because the ODI proprietary metadata server allows all developers to share the common metadata of a specific project.

A. Create a scenario from the variable and add the scenario to the load plan to create a case step.

B. Add a case step in the load plan and select a variable in the wizard.

C. Add a case step and drag the variable into the case step.

D. Drag the variable into the load plan and define a case step.

A. by using the import/export utilities

B. by using Opatch

C. by using Upgrade Assistant

D. by using ODI Studio

A. It is possible to define more than one physical schema associated to the same data server, but you must flag the default physical schema.

B. It is possible but it is better to avoid doing so because it is more difficult to define a logical schema this way.

C. ODI topology does not allow defining more than one physical schema for a data server; the associated logical schema would be ambiguous.

D. It is possible to define more than one physical schema associated to the same data server, but it is mandatory to specify a different user to log in.

A. Theintermediate integration table prefixed with I$ is createdbecause the flow control is mandatory when doing an initial load.

B. Neither the LKM northe IKM create intermediate tables. Most of their work is performed in the ODI Agent memory.

C. Theintermediate integration table prefixed with I$is required to determine which records must be inserted.

D. IfFlow Control is not necessary, an I$ table is not created.

A. extract and transform

B. extract and load

C. load and transform

D. transform only

A. Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save and regenerate this scenario.

B. Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save.

C. Link the last step of the package to its first step to create an infinite loop.

D. Drag the package to the last step in the package, run it asynchronously, and then save.