Oracle 1z0-448 Exam : Oracle Data Integrator 12c Essentials

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. 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.
• B. In the ODI Interface palette, choose the more convenient graphic objects to link the involved servers.
• C. 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.
• D. 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.

As part of your QA process you want to view code at the Step level in Operator. How must you proceed? (Choose the best answer.)

• A. Depending on the audit level declared when running the execution, some of the generated code at the step level can be viewed.
• B. All generated code can be viewed together at the step level, with a complete list of executed code.
• C. It is only possible to view code at the Task level.
• D. It is only possible to see code at the Session level.

Your customer wants a project in ODI, which contains a user function, to translate commands with different syntax for different technologies but with the same functionality.
How can you achieve this? (Choose the best answer.)

• A. It can be defined for every technology listed in the topology.
• B. An ODI procedure must be associated with it.
• C. A customize knowledge module is needed.
• D. The project must be explicitly mapped within an ODI mapping.

You must split a model with many database tables into multiple sub-models based on their names. How must you proceed? (Choose the best answer)

• A. Create new submodels and drag data stores individually to each submodel.
• B. Create new submodels and leverage the automatic distribution feature at the submodels level to automatically move the data stores based on their names.
• C. Use automatic distribution feature at the models level to automatically create the submodels and move the data stores based on their names.
• D. Create new models, drag the data stores individually to each model and then drag the models to the parent model to create submodels.

Which statement is correct about choosing the join order in an ODI Mapping when defining a join? (Choose the best answer.)

• A. This option is always available.
• B. You can never make this choice.
• C. This option may be available only if the underlying technology supports it.
• D. This option is inherited from reverse engineering.