Weekend Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: xmas50

Oracle 1z0-448 - Oracle Data Integrator 12cEssentials

Oracle 1z0-448 Premium Access     Download Demo    
Page: 1 / 3
Total 79 questions

How would a Knowledge Module, that is required to perform an aggregation in a Mapping, generate the correct code? (Choose the best answer.)

A.

The Knowledge Module must be customized because business rules and the physical implementation are strictly interlayed in ODI.

B.

The Knowledge Module must be customized only for aggregation functions.

C.

The Knowledge Module need not be customized because aggregation code is generated automatically by ODI according to the Mapping logic.

D.

The Knowledge Module need not be customized, but a variable must be used in the aggregate expression to generate the correct sum.

Which two objects can be dragged to a Mapping? (Choose two.)

A.

Variables

B.

Datastores

C.

Knowledge Modules

D.

Reusable Mappings

You have been tasked with designing a Mapping that must perform an initial load and incremental updates using the same transformation logic. How should you proceed? (Choose the best answer.)

A.

Create a single Mapping with two Physical Designs: one for theinitialload and one for the incremental updates.

B.

Create a single Mapping with a single Physical Design and modify it appropriately when an initial load is required or when an incremental update is required.

C.

Create two Mappings: one for the initial load and one for the incremental updates. Duplicate the transformation logic.

D.

Create a single Mapping and use variables in the Logical Design to do an initial load when required or an incremental update otherwise.

A Mapping that uses CDC does not load any source data and you want to check the SNP_CDC_SET table to find out the current window ID.

In which database schema must you look to find this table? (Choose the best answer.)

A.

the schema hosting the Work repository

B.

the schema hosting theWork schema of the default schema defined for your source data server

C.

the schema hosting the Staging Area

D.

SYS

Identify the ODI tool used to write content into a file in a package. (Choose the best answer.)

A.

OdiOutFile

B.

OdiFileCopy

C.

OdiFileMove

D.

OdiInFile

A.

Add a new subscriber and edit the default Journalizing filter in your Mappings.

B.

Drop the journal, add a new subscriber, start the journal, and edit the defaultJournalizing filter in your Mappings.

C.

Drop the journal, remove existing subscribers, add a new subscriber, start the journal, and edit the default Journalizing filter in your Mappings.

D.

Add a new subscriber, start the journal, and remove the default Journalizing filter in your Mappings.

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.

Which two statements are true about using ODI and Oracle GoldenGate together? (Choose two.)

A.

Oracle GoldenGate primarily performs aggregations for ODI.

B.

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

C.

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

D.

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

E.

ODI and Oracle GoldenGate enable real-time business intelligence.

You create two mappings that both use the same changed data and run at different times. One runs every 15 minutes and the other runs once every day.

What must you do to ensure that the Mapping that gets executed more often does not consume the changed data required by the other Mapping? (Choose the best answer.)

A.

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.

B.

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

C.

Duplicate the source data store for each Mapping.

D.

Create two distinct subscribers for each Mapping.

Which statement is true about the IKM SQL Control Append that creates an intermediate integration table prefixed with I$? (Choose the best answer.)

A.

Theintermediate integration table prefixed with I$is required to determine which records must be inserted.

B.

IfFlow Control is not necessary, an I$ table is not created.

C.

Theintermediate integration table prefixed with I$ is createdbecause the flow control is mandatory when doing an initial load.

D.

Neither the LKM northe IKM create intermediate tables. Most of their work is performed in the ODI Agent memory.