The source and target data stores are located on the same data server. Which statement is correct about the need for a Loading Knowledge Module to load the data on the target? (Choose the best answer.) A. Only an Integration…
Identify three capabilities of load plans. (Choose three.) A. restart from failed tasks B. exception handling C. native support for parallelism D. support for Open Tools E. restart of an agent
You need to reverse engineer a flat file that contains multiple record formats. How must you proceed? (Choose the best answer.) A. Create a Data Server by using the File technology and specify the various record formats while reverse engineering…
Which are the two correct statements about Work repositories? (Choose two.) A. They contain project and security information. B. They contain data models and execution information. C. They contain data and security information. D. They contain data models and project…
Identify the name of the default WebLogic data source created for the Master Repository when setting up a JEE domain. (Choose the best answer.) A. odiMasterRepository B. MasterRepository C. odimasterrepository D. ODIMasterRepository
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? (Choose the best answer.) A. You can…
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 the best answer.) A. Start a Mapping in Debug mode…
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.) A. Open the model, go to the Journalizing tab, and modify…
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.) A. Duplicate the Integration Knowledge Module, add an option CUSTOM_TEMPLATE, and…
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) A. It is not possible to use a…