Examcollection 1Z0-448 Questions are updated and all 1Z0-448 answers are verified by experts. Once you have completely prepared with our 1Z0-448 exam prep kits you will be ready for the real 1Z0-448 exam without a problem. We have Replace Oracle 1Z0-448 dumps study guide. PASSED 1Z0-448 First attempt! Here What I Did.

Q11. The source and target data stores are located on the same data server. Which statement is correct about the need for a Loading KnowledgeModule to load the data on the target?(Choose the best answer.) 

A. Only an Integration KnowledgeModule single-technology is required. 

B. Only an Integration Knowledge Module multitechnology is required. 

C. Aloading Knowledge Module multitechnology and an IntegrationKnowledgeModule single-technology are required. 

D. Both a Loading Knowledge Module multitechnology and an Integration Knowledge Module multitechnology are required. 

Answer:

Explanation: 

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


Q12. 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) 

A. Go to the Physical tab, select theFixedDesign check boxof the Physical Mapping Design. 

B. Go to the Physical tab, select the Is Frozen check box of the Physical Mapping Design. 

C. Go to the Physical tab, select the Read-only check box of the Physical Mapping Design. 

D. Go to the Physical tab, deselect theModify check boxof the Physical Mapping Design. 

Answer:

Explanation: 

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


Q13. 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:

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


Q14. 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 information. 

Answer:

Explanation: 

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


Q15. 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:

Explanation: 

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


Q16. 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 Mapping. 

B. Duplicate the Check Knowledge Module, add an optionCUSTOM_TEMPLATE, and set it within the Mapping. 

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_TEMPLATEfield. 

D. Duplicate the Loading Knowledge module, add an optionCUSTOM_TEMPLATE, and set it within the Mapping. 

Answer:

Explanation: 

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


Q17. Which statement is true about theIKM SQL Control Append thatcreates an intermediate integration table prefixed with I$?(Choose the best answer.) 

A. Theintermediate integration table prefixed with I$is required to determine which records must be inserted. 

B. IfFlow Control is not necessary, an I$ table is not created. 

C. Theintermediate integration table prefixed with I$ is createdbecause the flow control is mandatory when doing an initial load. 

D. Neither the LKM northe IKM create intermediate tables. Most of their work is performed in the ODI Agent memory. 

Answer:

Explanation: (http://www.oracle.com/us/products/middleware/data-integration/odi-performance-guide-wp-2147067.pdf) 


Q18. Identify the ODI tool used to write content into a file in a package.(Choose the best answer.) 

A. OdiOutFile 

B. OdiFileCopy 

C. OdiFileMove 

D. OdiInFile 

Answer:

Explanation: 

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


Q19. You are defining a data store in ODI metadata and want toadd 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 add a primary key even if it does not physically exist on the related database catalog, by adding constraintson the data store. 

B. You can add a primary key even if it does not physically exist on the related database catalog, by adding constraints to the data store diagram. 

C. You cannot add a primary key if it does not physically exist on the related database catalog. You can flag only non-null conditions to be checked. 

D. You cannot add a primary key if it does not physically exist on therelated database catalog. You can reverse engineer only the existing constraints. 

Answer:

Explanation: 

(https://docs.oracle.com/middleware/1212/odi/ODIKM/teradata.htm#ODIKM1061) 


Q20. Your project requires a loop through the same package logic 24/7. You must be able to purge those executions when required. How do you accomplish this?(Choose the best answer.) 

A. Link the last step of the package to its first step to create an infinite loop. 

B. Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save and regenerate this scenario. 

C. Create a scenario from the package, add the scenario as the last step in the package, run it asynchronously, and then save. 

D. Drag the package to the last step in the package, run it asynchronously, and then save. 

Answer:

Explanation: (http://www.rittmanmead.com/2015/04/di-tips-odi-convert-to-flow/)