Online Access Free 1z1-448 Exam Questions

You design 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.)

• A.Add a model to the package, set the Model step to Journalizing Model, and select the Extend Window and Lock Subscriber check boxes.
• B.Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Extend Window and Lock Subscriber check boxes.
• C.Add a sub model to the package, set the Sub-model step to Journalizing Sub-model, and select the Extend Window and Lock Subscriber check boxes.
• D.Add data stores to the package, set Datastores steps to Journalizing Datastore, and select the Unlock Subscriber and Purge Journal check boxes.

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

• A.You must deploy the generated code manually in a source or target server. You must copy all procedures generated into the development, test, and production servers.
• B.You must deploy the generated code manually in a source or target server. You must then compile the generated code and then double-check if the code prepared for the development server is the same as the code for the production server.
• C.You need not deploy the generated code manually in a source or target server. ODI prepares a package for the development environment.
• D.You need not deploy the generated code manually in a source or target server. ODI Agent coordinates the execution of commands prepared for the job, and executes them on the correct server.

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 theFile technology, create annXSDfile by using the Native Format Builder, and then reverse engineer it in a Model.
• C.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.
• 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 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 Step in Operator, edit the code, and save it.
• B.Open the Task in Operator, go to Code, click Query/Execution Plan to edit the code, and save it.
• C.It is not possible to modify the code once it has been generated.
• D.Open the Task in Operator, go to Code, click Edit, use Pre-execution Code to edit the code, and save it.

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.Right-click Datastore, select Changed Data Capture, and then select Order.
• B.Openthe model, go to the Journalizing tab, and modify the order there.
• 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.