You want to deploy the generated code manually in a source or target server, before executing a mapping in ODI. How can you accomplish this?(Choose the best answer.)
Answer : A
Explanation: (https://docs.oracle.com/middleware/1212/odi/ODIDG/intro.htm#ODIDG149)
You need to deploy ODI JEE Components on WebLogic Server. Where should you deploy them?(Choose the best answer.)
Answer : D
Explanation: (http://docs.oracle.com/cd/E25054_01/core.1111/e10106/odi.htm)
You need to reverse engineer a flat file that contains multiple record formats. How must you proceed?(Choose the best answer.)
Answer : D
Explanation: (https://blogs.oracle.com/dataintegration/entry/oracle_data_integrator_11_1)
You want tooverride the code generated by ODI and provide a custom SQL statementas the source of a Mapping. How must you proceed?(Choose the best answer.)
Answer : C
Explanation:
(https://blogs.oracle.com/dataintegration/entry/sessionizing_data_with_match_recognize)
You are working on notifications in a package and you must send an email containing an error message incase a Package step fails.
WhichodiRefmethod do you use to access the error message?(Choose the best answer.)
Answer : B
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIKD/odiref_reference.htm#ODIKD1147)
Youdesign a package with mappings that consume data from journalized data stores in
Consistent Set CDC mode. Which option represents the steps that must be performed at the beginning of your package to accomplish this?(Choose the best answer.)
Answer : C
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/data_capture.htm#ODIDG287)
Answer : B
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/data_capture.htm#ODIDG285)
Which statement is true about theIKM SQL Control Append thatcreates an intermediate integration table prefixed with I$?(Choose the best answer.)
Answer : D
Explanation: (http://www.oracle.com/us/products/middleware/data-integration/odi- performance-guide-wp-2147067.pdf)
You must monitor and managea co-located stand-alone agent,OracleDIAgent1, by using the ODI plug-in for Enterprise Manager CloudControl. Which is the correct command to start this agent on Linux?(Choose the best answer.)
Answer : A
Explanation: (https://community.oracle.com/thread/3780742?start=0&tstart=0)
You are using a customized reverse knowledge module. You want the execution to be performed in only the development data environment. Which statement is true?(Choose the best answer.)
Answer : C
Explanation:
(http://docs.oracle.com/cd/E23943_01/integrate.1111/e12643/create_rev_model.htm#ODID
G227)
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)
Answer : D
Explanation:
(http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/interfaces.htm#ODIDG1044)
You want to ensure that thePhysical Mapping Design cannot be modifiedeven if the Logical
Design of the Mapping is changed. What sequence of steps must you follow to achieve this?(Choosethe best answer)
Answer : C
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1560)
Which is the correct statement about the contents of Master repositories?(Choose the best answer.)
Answer : B
Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/admin_reps.htm#ODIDG155)
How are the ODI repositories upgraded?(Choose the best answer.)
Answer : A
Explanation: (http://odibeginnertutorials.blogspot.in/2013/12/odi-12c-installation-and-odi-
12c.html)