Free Oracle 1z0-482 Exam Dumps Questions & Answers

Select the two correct reasons that might lead you to use EDQ Transformation Processors rather than transform data in ODI.

• A.  The data needs to be mapped to a coded value.
• B.  When converting string dates, EDQ does not need all source fields to be valid dates.
• C.  EDQ is faster than ODI at performing transformations.
• D.  When a standardized or derived data value is needed for matching records.
• E.  Some data needs to be aggregated, producing a total value from multiple rows.

In ODI, when you add a column definition in a table, can you also use a technology-specific datatype for it?

• A.  No, datatypes are assigned by default as string variables.
• B.  Yes, it is possible to declare it, and if the desired datatype is not in the list available, you can also add it into a Topology datatypes definition.
• C.  Yes, it is possible to declare it but only if it is a standard SQL datatype.
• D.  Yes, it is possible but in any case, you need to forward-engineer the datatype via the JDBC driver.

Is it possible to invoke an ODI job as a public web service to execute it?

• A.  Yes, but you need to use as mandatory Oracle BPEL in order to process the job invocation.
• B.  Yes, both standalone and JEE agent support web services.
• C.  No, there are only internal specific application program interfaces that you can use to run a job.
• D.  No, it is only possible to run jobs internally or via command line.

What is a Load Plan?

• A.  A frozen version of a package.
• B.  An executable object that contains a hierarchy of steps.
• C.  A substitute for packages or scenarios-
• D.  A web service

Identify the operation that ensures that referential integrity is maintained while loading changes detected by the ODI CDC framework.

• A.  Purge Journal
• B.  Unlock Subscriber
• C.  Lock Subscriber
• D.  Extend Window