In ODI, is it possible to reverse a COBOL flat file using a Copybook definition?
Answer : A
Reference:
http://docs.oracle.com/cd/E28280_01/integrate.1111/e12643/create_rev_model.htm
(5.3.2.3)
In ODI Operator, is it possible to view code in the second level (the step) represented?
Answer : D
You have to load three tables A, B, and C in parallel, wait for them to be loaded, and then load a fourth table D. Which steps do you have to go through in order to do this?
Answer : A
In Topology, can a query be defined to retrieve native database sequences?
Answer : A
Identify two true statements regarding the ODI web-based components.
Answer : C,D
Explanation:
http://docs.oracle.com/cd/E17904_01/integrate.1111/e12643/odi_console.htm
In an ODI interface, is it mandatory to use a join to describe a lookup?
Answer : C
Select two correct statements about Results Books.
Answer : A,C
Explanation: http://www.oracle.com/webfolder/technetwork/data- quality/edqhelp/Content/concepts/results_books.htm
Identify the right variable step type to use when assigning a value to a variable with a SQL query.
Answer : C
Reference: http://docs.oracle.com/cd/E15586_01/integrate.1111/e12643/procedures.htm
(12.2.3.1)
Set Variable is the step type to assign the value. Refresh Variable is used to calculate the value from a sql query.
Identify two Change Data Capture implementation strategies provided through the ODI knowledge modules.
Answer : A,B
Identify two true statements regarding the ODI SDK.
Answer : A,D
To use ODI efficiently in a Data Warehouse project is it necessary to have a topology with an intermediate transformation server?
Answer : D
Is it possible to manage five metadata work repositories together with ODI and a single master repository in order to have a software lifecycle generation respecting the best practices that my company uses?
Answer : C
You are running a Scenario in a Load Plan using a Run Scenario step. This scenario contains the Interfaces. In case of failure in this Scenario, you would like to restart the
Interface that failed beginning. Which Restart Type option do you need to pick for the Run
Scenario step?
Answer : B
Explanation:
http://docs.oracle.com/cd/E38317_01/doc.11117/e37987/manageloadplans.htm#CIHJCBH
J -
Where can users edit scenarios in ODI?
Answer : D
Explanation: The scenario code (the language generated) is frozen, and all subsequent modifications of the components which contributed to creating it will not change it in any way http://docs.oracle.com/cd/E23943_01/integrate.1111/e12643/scenarios.htm
A step in the Package you are designing should not appear in the ODI logs. How do you implement this?
Answer : B