Oracle 1Z0-448 dumps - 100% Pass Guarantee!

Your package logic requires you to retrieve the status of the previous package step into a variable.

How must you implement this? (Choose the best answer.)

A. Create a variable, useodiRef.getPrevStepLog ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

B. Create a variable, useodiRef.getPrevInfo ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

C. Create a variable, useodiRef.getStep ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

D. Create a variable, useodiRef.getPrevStepStatus ()in the SQL query in its Refreshing tab, and add a variable as a Refresh Variable step into the package.

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

B. It is not possible to modify the code once it has been generated.

C. Open the Step in Operator, edit the code, and save it.

D. Open the Task in Operator, go to Code, click Query/Execution Plan to edit the code, and save it.

You are designing a package in which you want a certain step to not appear in the ODI logs. How do you accomplish this? (Choose the best answer.)

A. Right-click the step in Package Editor and select the No Logging menu item.

B. Modify Operator Navigator settings to disable that step from being displayed.

C. In Package Editor, click the step, go to the Advanced tab, and set Log Steps in the journal to Never.

D. Periodically schedule a scenario that usesOdiPurgeLogto remove that step from the ODI logs.