NEW QUESTION 1
Which are the two correct statements about Work repositories?(Choose two.)

• A. They contain project and security informatio
• B. They contain data models and execution informatio
• C. They contain data and security informatio
• D. They contain data models and project informatio

Answer: D

Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/admin_reps.htm#ODIDG155)

NEW QUESTION 2
You must send the same message in multiple packages to several email addresses stored in the same database table. How do you accomplish this by using a reusable package step?(Choose the best answer.)

• A. Create a procedure and add two task
• B. The first one must have a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and the second must have a Command on Target that usesOdiSendMailto send the email by using the bind variable defined in the first tas
• C. Createa Knowledge Modul
• D. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Command on Target that usesOdiSendMailto send the email using the bind variable defined in the Command on Sourc
• E. Create a counter variable that gets the total number of email addresses stored in the database tabl
• F. Next, create another variable that selects the email addresses from the database tabl
• G. Then, create a loop in the packages by using the variables and anOdiSendMailste
• H. Create a procedur
• I. Add a task with a Command on Source that reads the email addresses from the database table and stores them in a bind variable, and a Commandon Targetthat usesOdiSendMailto send the email using the bind variable defined in the Command on Sourc

Answer: B

Explanation:

(http://docs.oracle.com/cd/E21764_01/integrate.1111/e12643/procedures.htm#ODIDG408)

NEW QUESTION 3
You must split a model with many database tables into multiple sub-models based on their names. How must you proceed?(Choose the best answer)

• A. Create new submodels and drag data stores individually to each submode
• B. Use automatic distribution feature at the models level to automatically create the submodels and move the data stores based on their name
• C. Create new submodels and leverage the automatic distribution feature at the submodels level to automatically move the data stores based on their name
• D. Create new models, drag the data stores individually to each model and then drag the models to the parent model to create submodel

Answer: B

Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/organizing_documenting.htm#ODID G524)

NEW QUESTION 4
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 can you achieve this?(Choose the best answer.)

• A. The project must be explicitly mapped within an ODI mappin
• B. A customize knowledge module is neede
• C. An ODI procedure must be associated with i
• D. It can be defined for every technology listed in the topolog

Answer: D

Explanation:

(http://docs.oracle.com/cd/E23943_01/integrate.1111/e12643/procedures.htm#ODIDG464)

NEW QUESTION 5
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.)

• A. ./agent.sh –NAME=OracleDIAgent1 –PORT=20910
• B. ./agent.sh –NAME=OracleDIAgent1
• C. ./startComponent.sh OracleDIAgent1
• D. ./startComponent.sh OracleDIAgent1 –PORT=20910

Answer: A

Explanation:
(https://community.oracle.com/thread/3780742?start=0&tstart=0)

NEW QUESTION 6
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.)

• A. The execution should be done only on the development data environment, as long as the other environment is a mirrored cop
• B. Only the production environment can be use
• C. All environments linked to a logical schema can be used to reverse-engineer table structure
• D. Only a Java engine intermediate environment can be processe

Answer: C

Explanation:

(http://docs.oracle.com/cd/E23943_01/integrate.1111/e12643/create_rev_model.htm#ODID G227)

NEW QUESTION 7
Identify two correct statements about reusable Mappings.(Choose two.)

• A. They can have generic input and output signature
• B. They contain both a Logical and Physical Mapping desig
• C. They can be used within regular Mapping
• D. They can be executed directl
• E. They can be shared across project

Answer: AB

Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/mappings.htm#ODIDG1617)

NEW QUESTION 8
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?(Choose the best answer.)

• A. OdiWaitForData
• B. OdiWaitForCDCData
• C. OdiWaitForLogData
• D. OdiWaitForTable

Answer: A

Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/app_tools.htm#ODIDG967)

NEW QUESTION 9
You need to create a package that automatically sends an alert to users in case the third step fails.
Which option represents the steps to accomplish this?(Choose the best answer.)

• A. Add anOdiSendMailstep to My Package and link the My Third Package step to it by using a green OK arro
• B. Add anOdiSendMailstep to My Package and link the My Last Package step to it by using a red KO arro
• C. Add anOdiReadMailstep to My Package and link the My Third Package step to it by using a red KO arro
• D. Add anOdiSendMailstep to My Package and link the My Third Package step to it by using a red KO arro

Answer: B

Explanation:
(https://gurcanorhan.wordpress.com/2012/11/30/odi-alert-mechanism/)

NEW QUESTION 10
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.)

• A. numeric
• B. alphanumeric
• C. date
• D. text

Answer: A

Explanation:
(https://www.packtpub.com/packtlib/book/Big-Data-and-Business-Intelligence/9781849681742/4/ch04lvl1sec31/Using%20variables%20to%20control%20loo ps%20inside%20packages)

NEW QUESTION 11
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 i
• B. It is not possible to modify the code once it has been generate
• C. Open the Step in Operator, edit the code, and save i
• D. Open the Task in Operator, go to Code, click Query/Execution Plan to edit the code, and save i

Answer: D

Explanation:
(http://www.odigurus.com/2011/05/using-operator.html)

NEW QUESTION 12
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.)

• A. Duplicate theIntegration Knowledge Module, add an optionCUSTOM_TEMPLATE, and set it within the Mappin
• B. Duplicate the Check Knowledge Module, add an optionCUSTOM_TEMPLATE, and set it within the Mappin
• C. In the Physical tab of a Mapping, click one of the source data stores, select the Extract Options, and enter the SQL statement in theCUSTOM_TEMPLATEfiel
• D. Duplicate the Loading Knowledge module, add an optionCUSTOM_TEMPLATE, and set it within the Mappin

Answer: C

Explanation:

(https://blogs.oracle.com/dataintegration/entry/sessionizing_data_with_match_recognize)

NEW QUESTION 13
You need to deploy ODI JEE Components on WebLogic Server. Where should you deploy them?(Choose the best answer.)

• A. on the Coherence Server
• B. on the Administration Server
• C. on the Node Manager
• D. on the Managed Server

Answer: D

Explanation:
(http://docs.oracle.com/cd/E25054_01/core.1111/e10106/odi.htm)

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

• A. Use a dedicated schema such asODI_STAGIN
• B. UseTEM
• C. Use the same schema as the Data Schem
• D. Use SYSTE

Answer: A

Explanation:

(http://www.rittmanmead.com/2014/12/data-integration-tips-one-data-server/)

NEW QUESTION 15
Identify two correct Restart values for parallel steps in load plans.(Choose two.)

• A. Restart from new sessio
• B. Restart from failur
• C. Restart from failed childre
• D. Restart all childre

Answer: CD

Explanation:

(https://docs.oracle.com/middleware/1212/odi/ODIDG/loadplans.htm#ODIDG1409)

NEW QUESTION 16
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

Answer: BE

Explanation:
(https://docs.oracle.com/middleware/1212/odi/ODIDG/intro.htm#ODIDG113)

NEW QUESTION 17
Which two statements are true about ODI web-based components?(Choose two.)

• A. ODI Console allows administrators to edit users’ informatio
• B. Enterprise Manager Cloud Control provides access to ODI data servers’ setting
• C. ODI sessions can be monitored in Enterprise Manager Cloud Contro
• D. ODI Console provides access to project and mapping detail

Answer: AD

Explanation:
(http://www.oracle.com/technetwork/middleware/data-integrator/overview/oracledi-architecture-1-129425.pdf)

NEW QUESTION 18
......