Online Access Free 1z0-482 Practice Test

When working with delimited flat files, is it possible to enforce primary key on a flat file using a CKM?

• A.Yes, it is possible also to forward-engineer it to the flat file definition.
• B.No, it is not possible to enforce constraints on some technologies such as flat files and JMS queues.
• C.No, it is not possible to enforce constraints on any technology.
• D.Yes, but you have to save it as a fixed file.

To declare mapping on a target column, does a developer have to manually write the required database functions?

• A.No, a graphical expression editor can be used to drag and drop columns and the required function definitions.
• B.Yes, either the work area can be used to write the functions or a configuration file can be prepared for ODI to read.
• C.Yes, ODI only allows manual insertion of information related to source-target mappings.
• D.No, a developer must prepare a configuration file and associate to it a user function,

In an ODI interface, can source tables be declared as not joined?

• A.Yes, ODI generates the code calculating a sample of the data, profiling it, and deciding automatically if a join exists.
• B.No, by default, every added data store in the source declaration of an interface is joined with an inner join.
• C.No, in ODI, it is mandatory that all the source data stores are joined directly or indirectly.
• D.Yes, it is possible to create an ODI procedure to declare joins for the source tables.

Identify the database view ODI uses when loading the journalized data in an Interface.

• A.JV$I view
• B.T$ view
• C.JV$D view
• D.JV$ view

Identify three objects from which scenarios can be generated.

• A.Extract
• B.Trail
• C.Variable
• D.Knowledge modules
• E.Package
• F.Interface