Oracle Data Integrator: Integration and Administration Flashcards
Three ODI runtime components
ODI Operator
ODI standalone agent
ODI Repository
T/F. The information contained in the Master Repository is maintained with the Topology Navigator and the Security Navigator
True
Information contained in a Master Repository
Security information, including users, profiles and access privileges for the ODI platform.
Topology information, including technologies, definitions of servers and schemas, contexts and languages.
Old version of objects.
T/F. The contents of a Work Repository are managed by using Designer and Topology tabs. They are accessed by the agent at run time.
False
T/F. A Work Repository can be linked with several Master Repositories.
False
The contents of a Work Repository are managed by using Designer an Operator. They are also accessed by the agent at run time.
True
A Work Repository stores information for:
Data models, which include descriptions of schemas, datastore structures and metadata, fields and columns, data quality constraints, cross-references, data lineage, and so on.
Execution, which means scenarios, scheduling information and logs.
The Operator Navigator stores information in a Work Repository, while using the topology defined in the Master Repository.
True
What is an agent?
An agent is a runtime component of ODI that orchestrates the integration process.
At design time, developers generate scenarios from the business rules that they have designed. The code of these scenarios is retrieved from the repository by the agent at run time.
This agent then connects to the data servers, and orchestrates the code execution on these servers.
Which steps are performed to set up an ODI repository environment?
Create repository storage spaces.
Create repository schemas.
Create the Master Repository.
Create at one or more Work Repositories.
T/F. You must always use the RCU to create repositories.
False
T/F. A Work Repository can be linked with only one Master Repository for version management purposes.
True
Statements true about populating a new Master Repository
You can populate a new Master Repository by defining new objects in the Topology or Security tab in Studio.
You can populate a new Master Repository by importing an existing Master Repository that has been previously exported.
Creating the Master and Work Repositories can consists of:
Creating tables.
Importing definitions for the different technologies.
T/F. When you set up the topology for the development environment, it should mirror the most fragmented production environment.
True
T/F. ODI cannot implement load balancing between physical agents without WebLogic Server.
False
In a given context, how many physical resources can a logical resource be mapped to at the most?
One
For every agent that you have started, you only need to create one physical agent in the topology.
False.
You use a data server that has five technology-specific subdivisions. You want to use two of them in ODI. How many physical schemas should you define for that server?
Two
In how many contexts can a physical schema be used?
Any number.
The JDBC URL will be the same for any database.
False.
Privileges a user must have to integrate data into the database tables and reverse-engineer them.
SELECT, INSERT, UPDATE, CREATE, DROP AND READ.
T/F. The recommend practice in ODI is that you create the ODI temporary objects in the same area/schema as your target schema for you data server.
False
T/F When executing any object, the Default context is the context selected by default in the Execution dialog box. If an invalid context name is specified, the execution will fail.
False
T/F Contexts enable the same jobs (Development, Test, Production, and so on) to be executed on different databases and/or schemas.
True
Everything you create or modify in the Topology Navigator is stored where?
Master Repository.
You do not have to associate every logical schema with a physical schema, in every context; however, such unresolved schemas can never be used in the given context.
True
ODI connects to a data server by using standard Java connectivity methods, these methods generally require:
The drivers must be installed in the driver’s subdirectory.
Driver installation should be performed for the machine that will connect to the data server with an ODI graphical user interface.
You must specify appropriate settings to connect to the data server. The settings vary depending on the type of data server.
What does an Integration Knowledge Module (IKM) do?
Enforce constraints defined on the target datastores.
What does an Journalizing Knowledge Module (JKM) do?
Implement a particular strategy for loading the target of a mapping.
What does an Loading Knowledge Module (LKM) do?
Extract data from the source of mappings.
T/F UPDATE mode performs only updates. If no corresponding object exists, the import fails.
False.
ODI uses indexes for several reasons. Which reasons?
Indexes may speed up access to the table data when a query selects data through this group.
Unique indexes are a specific type of index that prevent duplicate values.
Relational database constraints concepts used to design ODI.
ODI is strongly based on the relational paradigm.
In ODI, data is handled through tabular structures that are defined as datastores.
How does ODI constraint ensure quality of data?
ODI constraint conditions define statements that must be true for each individual row of a table.
A candidate key can uniquely identify one row in a table
One of the keys is chosen as the primary key (PK)
Other keys are called alternate keys (AK)
T/F ODI has three methods for reverse engineering.
False.
A data model is?
An ODI description of a relational data model.
T/F The only way to create datastores in ODI is by reverse-engineering their structure from the database.
False.
What is a sub model?
A sub model is a group of several datastores in the same model.
Datastores can be arranged manually or automatically into sub models.
A sub model can be used to organize models into a meaningful tree structure – for example, models relating to customers.
Deduplication rules are comprised of:
Unique indexes.
Alternate keys.
Simple: column A = column B.
Primary keys.
What is a constraint in ODI?
A constraint is a statement that defines the rules that are enforced on the data in datastores.
A constraint ensures the validity of the data in a given datastore and the integrity of the data of a model.
Constraint on the target datastore are used in mappings to check the validity of the data before integration in the target.
In ODI, references can be represented by
Simple equalities between columns in tables.
Complex relationships between columns in tables.
An expression is
A business rule that is implemented as a SQL clause.
A transformation rule that maps attributes in source datastores onto one of the target datastore attributes.
Executed by a database server at run time.
T/F ODI requires a proprietary engine.
False
What is a Knowledge Module?
It is a template designed for a specific processing task, such as loading, integrating, or checking, in an integration process.
It is used to generate code from the business rules and other metadata that you defined in ODI.
A filter is used to
Reduce the amount of data that is loaded to the database.
Implement change capture.
How would you populate several targets simultaneously in ODI 12c from one source?
You need to insert several datastores in the target area.
What is a staging area?
The staging area is a special that must be created in a database.
In ODI, it is not necessary for all source datastores to be directly or indirectly joined.
False.
Types of advanced joins
Heterogeneous joins.
Joins between more than two datastores.
When creating filters it should be consider:
Filters defined on the datastores in their models are automatically copied into the diagram.
You can manually add additional filters in the diagram.
Valid lookup limitations.
“Left-outer-join” lookups will be available only on sources or staging technologies that support them.
“Expression-select” lookups will be available only on sources or staging technologies that support them.
What defines the flow?
Where the Staging are is located.
How mappings, filters and joins are set up.
Choice of knowledge modules.
T/F. Flow is the path taken by data from the sources to the target in an ODI interface.
True.
T/F You can always fix an error by correcting the code manually.
False.
Operator Navigator can be used to:
Show the execution log.
Display each interface as a session.
Stop, edit and restart sessions.
Errors observed in the Operator will have to be made to the interface in the Designer.
True.
A symptom of a wrong choice of the execution location.
A valid SQL clause that cannot be executed because it is on the wrong server, or poor performance if the code intended for a powerful server is executed on a desktop machine.
Common ODI errors that can be observed in the operator
A valid clause cannot be executed.
A clause is located at the wrong place (source/target), or needs to be performed in another command to work.
Incorrect execution context or incorrect agent chosen.
T/F Fixing code in the Operator has no impact on the interface.
True.
What are the three types of sequences
Native sequences.
Standard sequences.
Specific sequences.
T/F. If a rule is performed entirely within a DBMS, all ODI sequences are automatically updated.
False.
To generate a new sequence value for each row, your mapping should meet which conditions?
The mapping must be executed on the target.
The column must not be part of the update key.
The column must be set for insert but not update.
T/F One of the ODI 12c new variable actions is “No History”
True.
T/F ODI 12c has new variable actions available.
True.
T/F To track variables and sequences, logging levels should be set to 5.
False.
T/F JKMs are used to manage reverse engineering.
False
T/F At design time, you can refer to user functions in the same way as any regular database function.
True
T/F. CKMs are used to manage data quality.
True.
A user function always has:
One syntax: Defines how the function is called by other objects in ODI.
Several implementations specific to different technologies.
T/F LKMs are used to load the staging area temporary tables.
True
T/F RKMs are not used to perform a customized reverse engineering of data models for a specific technology.
True.
T/F You cannot duplicate an existing KM and start enhancing it by changing its technology or copying lines of code from another KM.
True.
T/F Options act like procedure parameters.
True
True statements about procedures:
A procedure can be executed manually for testing.
Procedures are usually run from a package.
True statements in regards to procedures:
A procedure is a sequence of commands executed by database engines, the operating system, or using the ODI tools.
Procedures are reusable components that can be inserted into packages.
Parameters must always be set in a command:
No parameters must be set in a command.
T/F The command sent to the source should return a result set, which is manipulated by the default command.
True.
Not a way to make a branch.
Use a Refresh Variable step.
The three most common package steps are:
Interface steps.
ODI tool steps.
Procedure steps.
Each step may have two possible next steps:
Next step upon success.
Next step upon failure.
T/F To create a sequence of reusable tool commands, you must create a procedure.
True.
T/F Variable steps are created by dragging an object into a package. This creates a reference to the variable.
True.
T/F Tool steps cannot be reused, but can be duplicated.
True.
T/F The Resume button resumes execution at the current cursor and continues until the session is finished or until a breakpoint is reached.
True.
The Run to Next Task button dose what?
It executes the current task and goes to the next task.
It goes to the next task if the current task has already been executed using Run to Task End.
T/F The Run to Step End button executes the current step but does not stop execution.
False.
Which of the following are benefits of the debugger for end users?
Debuggability of development projects
Hot debuggability in production.
Debuggability of random errors in concurrent executions.
During session execution what can be viewed?
Variables, threads and data.
