The source and target data stores are located on the same data server.
Which statement is correct about the need for a Loading Knowledge Module 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.
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.
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.
Identify the name of the default WebLogic data source created for the Master Repository when setting up a JEE domain. (Choose the best answer.)
A. odiMasterRepository
B. MasterRepository
C. odimasterrepository
D. ODIMasterRepository
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.
You must modify the order in which data stores are being journalized in a model. What sequence of steps do you follow to achieve this? (Choose the best answer.)
A. Openthe model, go to the Journalizing tab, and modify the order there.
B. Right-click Datastore, select Changed Data Capture, and then select Order.
C. Open the model, go to the Journalized tables tab, and modify the order there.
D. Open the data stores, go to the Journalizing tab, and modify the order there.
You need to troubleshoot the execution of a Mapping and visualize the data contained in the ODI Staging tables while the Mapping is being executed.
How must you proceed? (Choose the best answer.)
A. Start a Mapping in Debug mode and use breakpoints and the Get Data featureto query the data contained in the Staging tables.
B. Modifya Knowledge Module to dump the Staging tables' data into log files for review.
C. Use variables in a Package to query the Staging tablesand evaluate the variable values.
D. Reverse engineer the Staging tables in a Modeland review the data contained in it.
You are defining a data store in ODI metadata and want to add 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.
You want to override the code generated by ODI and provide a custom SQL statement as 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.
Which two statements are true about big data support in ODI? (Choose two.)
A. ODI uses its own transformation engine to process data in a Hadoop cluster.
B. ODI performs data transformations inside a Hadoop cluster.
C. ODI must perform data transformations outside Hadoop in an Oracle database.
D. ODI allows moving data in and out of a Hadoop cluster.
Nowadays, the certification exams become more and more important and required by more and more enterprises when applying for a job. But how to prepare for the exam effectively? How to prepare for the exam in a short time with less efforts? How to get a ideal result and how to find the most reliable resources? Here on Vcedump.com, you will find all the answers. Vcedump.com provide not only Oracle exam questions, answers and explanations but also complete assistance on your exam preparation and certification application. If you are confused on your 1Z0-448 exam preparations and Oracle certification application, do not hesitate to visit our Vcedump.com to find your solutions here.