Q1. 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 the file. 

B. Create a Data Server by using the XML technology, create annXSDfile by using the Native Format Builder, and then reverse engineer it in a Model. 

C. Create a Data Server by using theFile technology, create annXSDfile by using the Native Format Builder, and then reverse engineer it in a Model. 

D. Create a Data Server by using the Complex File technology, create annXSDfile by using the NativeFormat Builder, and then reverse engineer it in aModel. 

View Answer

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

A. ODI Runtime Agent 

B. ODI Standalone Agent 

C. ODI JEE Agent 

D. ODI Colocated Standalone Agent 

View Answer

Q3. You are designing a load plan in which you must create multiple branches based on the value of a variable. How do you accomplish this by using Load Plan Editor?(Choose the best answer.) 

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

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

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

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

View Answer

Q4. A. Add a new subscriber and edit the default Journalizing filter in your Mappings. 

B. Drop the journal, add a new subscriber, start the journal, and edit the defaultJournalizing filter in your Mappings. 

C. Drop the journal, remove existing subscribers, add a new subscriber, start the journal, and edit the default Journalizing filter in your Mappings. 

D. Add a new subscriber, start the journal, and remove the default Journalizing filter in your Mappings. 

View Answer

Q5. You want to modify the code generated by a failed Task and restart the session. How must you proceed?(Choose the best answer.) 

A. Open the Task in Operator, go to Code, click Edit, use Pre-execution Code to edit the code, and save it. 

B. It is not possible to modify the code once it has been generated. 

C. Open the Step in Operator, edit the code, and save it. 

D. Open the Task in Operator, go to Code, click Query/Execution Plan to edit the code, and save it. 

View Answer

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

A. conditions 

B. foreign keys 

C. primary keys 

D. alternate keys 

E. not null 

View Answer

Q7. What must you set on the Definition tab of a variable to protect the variable value from being displayed in the Operator logs?(Choose the best answer.) 

A. Select the Secure Value check box. 

B. Select the Hide Value check box. 

C. Set the Keep History field to No History. 

D. Leave the Default Value field empty. 

View Answer

Q8. If multiple changes occur on the source system but have not yet been processed by ODI, the J$ table contains entries for each change for the records sharing the same PK. 

What happens at run time when a Mapping gets executed?(Choose the best answer.) 

A. All distinct entries are processed. 

B. Only the latest entry is processed based on theJRN_DATEfield. 

C. Only the first entry is processed based on theJRN_DATEfield. 

D. A PK violation occurs due to the duplicated entries and the entries are inserted in the E$ table. 

View Answer

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

A. numeric 

B. alphanumeric 

C. date 

D. text 

View Answer

Q10. You are setting up the topology for an infrastructure with three different environments: Dev, QA, and Prod. How must you create Logical Schemas?(Choose the best answer.) 

A. Create one Logical Schema per Physical Schema. 

B. Create one Logical Schema per Physical Schema that stores the same type of data. 

C. Create one Logical Schema per Data Server. 

D. Create one Logical Schema per Context. 

View Answer