1Z0-448 Exam Questions

You have to loop through a Mapping step three times in a package by using variables. Identify the correct variable data type to create the loop. (Choose the best answer.)

The workflow you are designing requires checking to see whether there are records available in a source table before doing anything. Which ODI tool must you use to implement this?...

Which statement is true about the need to have a topology with an intermediate server, in order to use ODI correctly in a data warehouse project? (Choose the best answer.)

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

How do you provide a timeout value for an exception step? (Choose the best answer.)

You need to implement security mechanisms that allow only user "A" to view all the Mappings contained in a specific project named "P1." How must you proceed? (Choose the best answe...

How can you define the order in which target data stores are loaded in a Mapping? (Choose the best answer.)

Identify the correct variable step type to use when assigning a value to a variable with an SQL query. (Choose the best answer.)

You need to create a Model that works with multiple underlying technologies. How must you proceed? (Choose the best answer.)

How would a Knowledge Module, that is required to perform an aggregation in a Mapping, generate the correct code? (Choose the best answer.)

Which statement is correct about all expressions in a Mapping? (Choose the best answer.)

You are designing a package in which you want a certain step to not appear in the ODI logs. How do you accomplish this? (Choose the best answer.)

Is it possible to invoke an ODI job as a public web service to execute it?

To load a specific table using ODI, do you need to draw directly in the flow all details about how the different servers involved are connected?

In a Mapping, you want to load the data by using a specific partition that is declared for a target table. Which statement is correct in this situation? (Choose the best answer)

You want to override the code generated by ODI and provide a custom SQL statement as the source of a Mapping. How must you proceed? (Choose the best answer.)

You must modify the order in which data stores are being journalized in a model. What sequence of steps do you follow to achieve this? (Choose the best answer.)

You need to troubleshoot the execution of a Mapping and visualize the data contained in the ODI Staging tables while the Mapping is being executed. How must you proceed? (Choose th...

You are defining a data store in ODI metadata and want to add a primary key even if it does not physically exist on the related database catalog. How can you accomplish this? (Choo...

How does the data flow when moving records between two servers by using Database Links and an Agent installed on a middle-tier server? (Choose the best answer.)

You are a project developer using ODI and want to consolidate your own local metadata repositories. Identify the true statement. (Choose the best answer.)

How should you define the Work Schema of a Physical Schema? (Choose the best answer.)

You have been tasked with designing a Mapping that must perform an initial load and incremental updates using the same transformation logic. How should you proceed? (Choose the bes...

Select the correct statement. When running an interface in ODI, is it possible to see a simu-lation of the code?

In an ODI interface, is it mandatory to use a join to describe a lookup?

Identify two benefits that are unique to ODI JEE Agents. (Choose two.)

Which statement is true about the IKM SQL Control Append that creates an intermediate integration table prefixed with I$? (Choose the best answer.)

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...

Which ODI Agent is deployed in Oracle WebLogic Server? (Choose the best answer.)

If an ODI user function has one syntax and one or more implementations, can it be used in an ODI interface mapping?

You want to add a new CDC subscriber in ODI after you have started the Journal process, what steps do you need to go through in order to use this new subscriber?

How are the ODI repositories upgraded? (Choose the best answer.)

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

Which tables created by ODI contain error records? (Choose the best answer.)

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 ca...