Black Friday Sale - Special 70% Discount Offer - Ends in 0d 00h 00m 00s - Coupon code: 70dumps

1z0-448 Questions and Answers

Question # 6

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

Full Access
Question # 7

Identify two constraints that can be used to ensure uniqueness in ODI. (Choose two.)

A.

conditions

B.

foreign keys

C.

primary keys

D.

alternate keys

E.

not null

Full Access
Question # 8

How should you define the Work Schema of a Physical Schema? (Choose the best answer.)

A.

Use a dedicated schema such asODI_STAGING.

B.

UseTEMP.

C.

Use the same schema as the Data Schema.

D.

Use SYSTEM.

Full Access
Question # 9

What must you set on the Definition tab of a variable to protect the variable value from being displayed in the Operator logs? (Choose the best answer.)

A.

Select the Secure Value check box.

B.

Select the Hide Value check box.

C.

Set the Keep History field to No History.

D.

Leave the Default Value field empty.

Full Access
Question # 10

Which statement is correct about choosing the join order in an ODI Mapping when defining a join? (Choose the best answer.)

A.

This option is inherited from reverse engineering.

B.

This option is always available.

C.

You can never make this choice.

D.

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

Full Access
Question # 11

You need to reverse engineer a flat file that contains multiple record formats. How must you proceed? (Choose the best answer.)

A.

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

B.

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.

C.

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

D.

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

Full Access