1Z0-482 Exam Questions

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

You are designing a Load Plan in which you need to run Interfaces A and B one after the other while running Interface C at the same time. Which steps do you need to follow to achie...

When profiling data with EDQ, how can you ensure that the latest data is being used?

Which tables store ODI/OBIEE lineage information?

To load a specific table using ODI, do you need to draw directly in the flow all details about how the different servers involved are connected?

Is it possible to monitor a JEE Agent using a plug in directly into Enterprise Manager Fusion Middleware Control Console?

What is a relationship in a matching process?

One of the parameters retrieve column properties in a knowledge module is odiRef.getcolList. What is the name of the parameter that retrieves the datatype of a mapped target column...

Select four correct scenarios where EDQ parsing is beneficial.

The ODI application adapter for Hadoop______.

Select the correct statement. When running an interface in ODI, is it possible to see a simu-lation of the code?

Which property file parameter stores the location of the OBBIE web catalog folder?

When using a customized reverse knowledge module, can the execution be done only on the development environment?

Which one of the following attributes should always be provided to EDQ AV as a separate attribute if available?

Identify two parameters of the OGG JKMs that must be set in order to configure OGG through ODI.

Select two correct answers. ODI and EDQ can share the same infrastructure If__________.

You are designing a Load Plan in which you need to create multiple branches based on the value of a variable. How do you implement this using the Load Plan editor?

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

In ODI, can a check constraint be added to metadata?

In an ODI Interface, can filters be added automatically?

Your Package logic requires you to retrieve the status of the previous Package step into a variable. How do you implement this?

Select the correct statement in an ODI interface, each column of the target can have at most, one mapping in a given dataset.

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

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

In ODI, is it possible to reverse a COBOL flat file using a Copybook definition?

In ODI Operator, is it possible to view code in the second level (the step) represented?

You have to load three tables A, B, and C in parallel, wait for them to be loaded, and then load a fourth table D. Which steps do you have to go through in order to do this?

In Topology, can a query be defined to retrieve native database sequences?

Identify two true statements regarding the ODI web-based components.

In an ODI interface, is it mandatory to use a join to describe a lookup?

Identify the right variable step type to use when assigning a value to a variable with a SQL query.

Identify two Change Data Capture implementation strategies provided through the ODI knowledge modules.

Identify two true statements regarding the ODI SDK.

To use ODI efficiently in a Data Warehouse project is it necessary to have a topology with an intermediate transformation server?

Is it possible to manage five metadata work repositories together with ODI and a single master repository in order to have a software lifecycle generation respecting the best pract...

You are running a Scenario in a Load Plan using a Run Scenario step. This scenario contains the Interfaces. In case of failure in this Scenario, you would like to restart the Inter...

A step in the Package you are designing should not appear in the ODI logs. How do you implement this?

In an ODI package, is it possible to use a tool to purge logs based on the name of the agent that executed the session?

When defining a data store in ODI metadata, is it possible to add a primary key even if it does not physically exist on the related database catalog?

What is a Load Plan?

Can a project in ODI contain a user function to translate commands with different syntax for different technologies but with the same functionality?

Select the statement that best describes the difference between Server and Client Data Store access.

If an ODI user function has one syntax and one or more implementations, can it be used in an ODI interface mapping?

When the data, source, and target are persistent in the same data server, in an ODI interface, do you need an LKM and an LKM to load the data on target?

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

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

Updates have been made to Interfaces in a Package. What would you do to make sure the Production team runs a scenario containing those updates while preserving the existing scenari...

After invoking an Enterprise Data Quality Job from ODI, where can you monitor the detailed progress of that Job?

Which two ODI knowledge modules are included in the Application Adapter for Hadoop?

You want to add a new CDC subscriber in ODI after you have started the Journal process, what steps do you need to go through in order to use this new subscriber?