1Z0-482 - Oracle Data Integrator 11g Certified Implementation Essentials
Go back to Oracle
Select two infrastructure components that can be used to deploy both ODI and EDQ components.
Oracle WebLogic Server
IBM WebSphere Application Server
Prior to executing an interface or mapping in ODI, do you have to deploy the generated code manually in a source or target server?
No, ODI Agent coordinates the execution of the commands prepared for the job, and executes them on the correct server.
Select the two correct statements about the Date Profiler.
It provides a distribution for the day in the year, such as February 21, regardless of the year.
By clicking a date in blue, the user can drill down to the records that carried that value.
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 scenario's schedule?
Regenerate existing scenario
Identify the operation that ensures that referential integrity is maintained while loading changes detected by the ODI CDC framework.
Select the correct statement in an ODI interface, each column of the target can have at most, one mapping in a given dataset.
Yes, a target column can have a unique and well-defined mapping.
Which two ODI knowledge modules are included in the Application Adapter for Hadoop?
IKM Hive Transform
IKM File to Hive
Select four correct scenarios where EDQ parsing is beneficial.
There are separate attributes for Titles, Forenames, and Family names, but the values are not always in the right fields.
The data contains product descriptions in the string field and you need to extract the size and weight of each product.
Addresses are contained in a single string field and are difficult to verify.
Phone numbers are sometimes embedded in the customer name and address.
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?
When working with delimited flat files, is it possible to enforce primary key on a flat file using a CKM?
No, it is not possible to enforce constraints on some technologies such as flat files and JMS queues.
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 Interface that failed beginning. Which Restart Type option do you need to pick for the Run Scenario step?
Restart from failed step
In an ODI interface, is it possible to use a specific partition if it is declared for the target table to load data?
Yes, an option in the interface can be used to declare the partition that has to be used for the loading.
Is it possible to invoke an ODI job as a public web service to execute it?
Yes, both standalone and JEE agent support web services.
Which one of the following attributes should always be provided to EDQ AV as a separate attribute if available?
Zip or Postal code
The ODI application adapter for Hadoop______.
is a Big Data Connector
To declare mapping on a target column, does a developer have to manually write the required database functions?
No, a graphical expression editor can be used to drag and drop columns and the required function definitions.
What is a relationship in a matching process?
It is matching functions that determine how well two records match each other, for a given identifier.
In an ODI interface, to declare a lookup, is there a dedicated graphical object?
Yes, there is a specific object, you click it and a wizard helps the developer to set the lookup.
Select the statement that best describes the difference between Server and Client Data Store access.
Data is accessed from Server only if it is the data store.
To use ODI efficiently in a Data Warehouse project is it necessary to have a topology with an intermediate transformation server?
It is mandatory to collect data directly from sources into a data warehouse server using real time replication processes.
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?
Add a Case Step in Load Plan and select variable- in the wizard
Identify two true statements regarding the ODI SDK.
The ODI SDK is used to load data between Teradata and Oracle.
The ODI SDK allows developers to execute most ODI operations through a Java program.
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?
Generate three scenarios to load A, B, and C, add them to a Package, set their Synchronization mode to Asynchronous, use an OdiWaitForChildSession step before adding an Interface to load D
What is a Load Plan?
An executable object that contains a hierarchy of steps.
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 achieve this?
Add a Parallel step, add two Serial steps underneath it, and then add A and B to one serial step and C to the other one
In an ODI interface, if a business rule is declared to calculate a sum aggregation, does a knowledge module need to be customized in order to create the correct code?
No, aggregation code is generated automatically by ODI according to the mapping logic rules.
In ODI, when you add a column definition in a table, can you also use a technology-specific datatype for it?
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.
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 practices that my company uses?
Yes, it is possible to create separate metadata environments with work repositories, that define for instance, a current level of development work repository, next level development, maintenance, production, and so on.
Which property file parameter stores the location of the OBBIE web catalog folder?
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?
Add anew subscriber and edit the default Journalizing filter in your Interfaces
Which tables store ODI/OBIEE lineage information?
Work repository tables
In an ODI Interface, when defining a join, can you always choose "Ordered Join Syntax"?
Yes, this option is always available.
In an ODI interface, is it mandatory to use a join to describe a lookup?
No, there is a graphical object dedicated to set a lookup in the source area of an interface.
When profiling data with EDQ, how can you ensure that the latest data is being used?
By refreshing a snapshot by running it
In ODI Operator, is it possible to view code in the second level (the step) represented?
No, it is possible to view code in the thud level(the tasklevel)represented.
Is it possible to monitor a JEE Agent using a plug in directly into Enterprise Manager Fusion Middleware Control Console?
Yes, it is possible to check that an Agent is active or if it has any issues.
Select the correct statement. When running an interface in ODI, is it possible to see a simu-lation of the code?
Yes, before executing the interface, it is possible to set a flag to request the code simulation.
After invoking an Enterprise Data Quality Job from ODI, where can you monitor the detailed progress of that Job?
In ODI Console
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?
No, only an IKM single technology is required.
In an ODI interface, can source tables be declared as not joined?
No, in ODI, it is mandatory that all the source data stores are joined directly or indirectly.
Do all project developers using ODI need to consolidate their own local metadata repositories?
No, ODI uses a centralized relational metadata repository that all the developers share.
Select the two correct reasons that might lead you to use EDQ Transformation Processors rather than transform data in ODI.
Some data needs to be aggregated, producing a total value from multiple rows.
When converting string dates, EDQ does not need all source fields to be valid dates.
When using a customized reverse knowledge module, can the execution be done only on the development environment?
No, all environments linked to a logical schema can be used to reverse-engineer table structure,
Select the three correct options for Token Checking in the EDQ parser.
Checking against a list of values.
Checking for duplicates.
Checking against a list of regular expressions.
In Topology, can a query be defined to retrieve native database sequences?
Yes, in the technology details in the Topology submodule, there is a tab that defines queries for specific database elements.
Identify the right variable step type to use when assigning a value to a variable with a SQL query.
Can a project in ODI contain a user function to translate commands with different syntax for different technologies but with the same functionality?
Yes, it can be defined for every technology that is listed in Topology.
You are loading a file into a database but the file name is unknown at design time and will have to be passed dynamically to a Package at run time; how do you achieve this?
Create a variable, use it as the Resource Name of the File datastore, and add it to a package as a Declare Variable step
Identify two Change Data Capture implementation strategies provided through the ODI knowledge modules.
Identify the database view ODI uses when loading the journalized data in an Interface.