Oracle 1z0-448 Oracle Data Integrator 12cEssentials Exam Practice Test

This option is inherited from reverse engineering.

This option is always available.

You can never make this choice.

This option may be available only if the underlying technology supports it.

All distinct entries are processed.

Only the latest entry is processed based on theJRN_DATEfield.

Only the first entry is processed based on theJRN_DATEfield.

A PK violation occurs due to the duplicated entries and the entries are inserted in the E$ table.

Oracle GoldenGate primarily performs aggregations for ODI.

Oracle GoldenGate and ODI are used together primarily for running weekly batch jobs.

Oracle GoldenGate provides non-invasive changed data capture capabilities to ODI.

ODI starts and stops Oracle GoldenGate processes automatically during a Mapping execution.

ODI and Oracle GoldenGate enable real-time business intelligence.

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

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

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

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

extracting source data to flat files

triggers

Oracle GoldenGate

before-and-after database image comparison

Add a parallel step, add three serial steps underneath it, then addAto the first parallel step, B to the second one, and C to the last one.

Create a scenario from the variable and add the scenario to the load plan to create a case step.

Add a parallel step, add two parallel steps underneath it, then add A and B tooneparallel step, and C to the other.

Add a parallel step, add two serial steps underneath it, then add A and B to one serial step, and C to the other.

Use Consistent CDC, do not perform a purge of the journal data when the first Mapping gets executed, and manually change theJRN_SUBSCRIBERcolumn in the correspondingJ$table to keep the changed data present for the second Mapping.

Create a third mapping to copy the changed data to a staging table, which is used as the source of the second Mapping.

Duplicate the source data store for each Mapping.

Create two distinct subscribers for each Mapping.

Create a Data Server by using the File technology and specify the various record formats while reverse engineering the file.

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.

Create a Data Server by using theFile technology, create annXSDfile by using the Native Format Builder, and then reverse engineer it in a Model.

Create a Data Server by using the Complex File technology, create annXSDfile by using the NativeFormat Builder, and then reverse engineer it in aModel.

OdiOutFile

OdiFileCopy

OdiFileMove

OdiInFile

high availability

minimal footprint

access to WebLogic connection pools

management in Enterprise Manager Cloud Control

Create one Logical Schema per Physical Schema.

Create one Logical Schema per Physical Schema that stores the same type of data.

Create one Logical Schema per Data Server.

Create one Logical Schema per Context.