Labour Day Sale Limited Time 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: buysanta

Exact2Pass Menu

Login / Register

Question # 4

Identify two correct exception behavior values for Run Scenario steps in load plans. (Choose two.)

A.

Run Exception and Restart

B.

Run Exception and Continue

C.

Run Exception and Ignore

D.

Run Exception and Fail

E.

Run Exception and Raise

Full Access
Question # 5

You are working on notifications in a package and you must send an email containing an error message in case a Package step fails.

Which odiRef method do you use to access the error message? (Choose the best answer.)

A.

odiRef.getSession()

B.

odiRef.getInfo()

C.

odiRef.getPrevStepLog()

D.

odiRef.getStep()

Full Access
Question # 6

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.

Full Access
Question # 7

Identify two implementation strategies of changed data capture provided through ODI Knowledge Modules. (Choose two.)

A.

extracting source data to flat files

B.

triggers

C.

Oracle GoldenGate

D.

before-and-after database image comparison

Full Access
Question # 8

You need to create a Model that works with multiple underlying technologies. How must you proceed? (Choose the best answer.)

A.

This works only for Oracle and Informix.

B.

This works only for Oracle and MySQL.

C.

Create a new generic technology to support it.

D.

Use the out-ofthe box Generic SQL technology.

Full Access
Question # 9

You need to create a package that automatically sends an alert to users in case the third step fails.

Which option represents the steps to accomplish this? (Choose the best answer.)

A.

Add anOdiSendMailstep to My Package and link the My Third Package step to it by using a green OK arrow.

B.

Add anOdiSendMailstep to My Package and link the My Last Package step to it by using a red KO arrow.

C.

Add anOdiReadMailstep to My Package and link the My Third Package step to it by using a red KO arrow.

D.

Add anOdiSendMailstep to My Package and link the My Third Package step to it by using a red KO arrow.

Full Access
Question # 10

Which is the correct statement about the contents of Master repositories? (Choose the best answer.)

A.

They contain data model and security information.

B.

They contain security and topology information.

C.

They contain project and topology information.

D.

They contain project and security information.

Full Access
Question # 11

You are setting up the topology for an infrastructure with three different environments: Dev, QA, and Prod. How must you create Logical Schemas? (Choose the best answer.)

A.

Create one Logical Schema per Physical Schema.

B.

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

C.

Create one Logical Schema per Data Server.

D.

Create one Logical Schema per Context.

Full Access