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

You want to ensure that the Physical Mapping Design cannot be modified even if the Logical Design of the Mapping is changed.

What sequence of steps must you follow to achieve this? (Choose the 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.

Which statement is correct about the tasks that Standalone Agents perform? (Choose the best answer.)

A. They update or modify code to be executed, check security, select database servers, and update log files after execution.

B. They schedule scenarios to be executed, check security, constraints and update log files after execution.

C. They retrieve code from the execution repository and request database servers, operatingsystems, or scripting engines for execution.

D. They schedule code from the execution repository and update log files after execution.

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.

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.

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 tasks. 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 task.

B. Createa Knowledge Module. 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 Source.

C. Create a counter variable that gets the total number of email addresses stored in the database table. Next, create another variable that selects the email addresses from the database table. Then, create a loop in the packages by using the variables and anOdiSendMailstep.

D. Create a procedure. 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 Source.