Download ODI Interview Questions and Answers PDF

TitleODI Interview Questions and Answers
File Size534.9 KB
Total Pages13
Document Text Contents
Page 1

Page 2

IFOCUS Chakradhar [email protected]

Oracle Data Integrator (ODI) consists of following products

1. Repository - is relational Databases to store objects used/configured or developed by ODI.

There are two type of Repository Master Repository (one and only one) and Work Repository

(one or more)

a) Master Repository - There is only one Master repository and used to store security

information, topology information (servers..) and versions of the Objects. All Modules

(designer, operator, topology & security) have access to master repository.

b) Work Repository- Work related objects (project objects) are stored in Work Repository like

Models, Projects and run-time information. There could be multiple work repository per

installation and all linked to single master repository. Work Repository is accessed by

Designer/Operator Module and run time agent.

2. Graphical Modules -

a) Designer (|bat)- All project development takes place in this module and this is the

place where database and application metadata are imported and defined.

b) Operator (|bat) - usually to monitor production ODI instance and shows

execution logs, rows processed and execution statistics

c) Topology Manager (|bat)- To register servers, schema and agents in master


d) Security Manager (|bat) - To manage user profiles and their access privileges.

3. Runtime Component / Scheduler Agent - scheduler agent coordinates execution of

scenarios. Scheduler Agent retrieves code from execution repository and then requests database

server, scripting engine or operating system server to execute that code.

4. Metadata Navigator (MN)- is Web (JSP/Servlet) application (available as oracledimn.war)

that enables access to repository through Web Interface (Web Browser). MetaData Navigator

(MN) requires Application Server and you deploy MN application oracledimn.war on pre-

installed application server (Tom Cat, OAS, WebLogic). This is optional component.

What are the types of Variables?
1) Global

2) Project

A variable is an object that stores a single value. This value can be a string, a number or a date. The value

is stored in Oracle Data Integrator, and can be updated at run-time.

The value of a variable can be updated from the result of a query executed on a logical schema. For

example, it can retrieve the current date and time from a database.

A variable can be created as a global variable or in a project. Global variables can be used in all projects,

while project variables can only be used within the project in which they are defined.

Page 7

IFOCUS Chakradhar [email protected]

- Oracle Data Quality for Data Integrator

- Oracle Data Profiling

4) What is Oracle Data Integration Suite?

Oracle data integration suite is a set of data management applications for building, deploying,

and managing enterprise data integration solutions:

 Oracle Data Integrator Enterprise Edition

 Oracle Data Relationship Management

 Oracle Service Bus (limited use)

 Oracle BPEL (limited use)

 Oracle WebLogic Server (limited use)

Additional product options are:

 Oracle Goldengate

 Oracle Data Quality for Oracle Data Integrator (Trillium-based DQ)

 Oracle Data Profiling (Trillium based Data Profiling)

 ODSI (the former Aqualogic Data Services Platform)

5) What systems can ODI extract and load data into?
ODI brings true heterogeneous connectivity out-of-the-box, it can connect natively to Oracle,

Sybase, MS SQL Server, MySQL, LDAP, DB2, PostgreSQL, Netezza.

It can also connect to any data source supporting JDBC, its possible even to use the Oracle BI

Server as a data source using the jdbc driver that ships with BI Publisher

6) What are Knowledge Modules?
Knowledge Modules form the basis of 'plug-ins' that allow ODI to generate the relevant

execution code , across technologies , to perform tasks in one of six areas, the six types of

knowledge module consist of:

 Reverse-engineering knowledge modules are used for reading the table and other object

metadata from source databases

 Journalizing knowledge modules record the new and changed data within either a single

table or view or a consistent set of tables or views

 Loading knowledge modules are used for efficient extraction of data from source

databases for loading into a staging area (database-specific bulk unload utilities can be

used where available)

 Check knowledge modules are used for detecting errors in source data

 Integration knowledge modules are used for efficiently transforming data from staging

area to the target tables, generating the optimized native SQL for the given database

Page 12

IFOCUS Chakradhar [email protected]

Qs> Does ODI support web services?

Yes, ODI is ‘SOA’ enabled and its web services can be used in 3 ways:

The Oracle Data Integrator Public Web Service, that lets you execute a scenario (a

published package) from a web service call

Data Services, which provide a web service over an ODI data store (i.e. a table, view

or other data source registered in ODI)

The ODIInvokeWebService tool that you can add to a package to request a response

from a web service

Qs> Is ODI Used by Oracle in their products?

Yes there are many Oracle products that utilise ODI, but here are just a few:

Oracle Application Integration Architecture (AIA)

Oracle Agile products

Oracle Hyperion Financial Management

Oracle Hyperion Planning

Oracle Fusion Governance, Risk & Compliance

Oracle Business Activity Monitoring

Oracle BI Applications also uses ODI as its core ETL tool in place of Informatica ,

but only for one release of OBIA and when using a certain source system.


•The ability to dynamically manage a staging area

•The ability to generate code on source and target systems alike, in the same


•The ability to generate native SQL for any database on the market—most ETL

tools will generate code for their own engines, and then translate that code for the

databases—hence limiting their generation capacities to their ability to convert

proprietary concepts

•The ability to generate DML and DDL, and to orchestrate sequences of operations

on the heterogeneous systems

1. What is Oracle Data Integrator ?

2. Can we call ODI as a ETL tool. If yes then How ?

Page 13

IFOCUS Chakradhar [email protected]

3. Is it a ELT tool? Explain.

4. What are the new features available in ODI 11g?

5. What is agent in ODI. Differentiate local agent and java ee agent.

6. What is the role of context ?

7. What is logical schema ? What is the importance of it ?

8. Explain ODI Architecture.

9. What is the error handling mechanism available in ODI ?

10. What is the difference between flow_control vs static_control ?

11. What are knowledge modules ? Which kind of codes they support.

12. What are different ODI Tools you knows ?

13. How interface works with aggregation ?

14. What is dataset and how they are helpful in interface ?

15. What do you mean by control append and incremental update ?

16. What is scenario in ODI and why it is required ?

17. What is local variable and global variable in ODI. How can we access them inside KM

and procedures ?

18. What are the different datatypes and history of an ODI variable ?

19. What is temporary interface ? How they are helpful ? Give some scenarios on this.

20. Can we use a sql query as source in interface ? if yes then how if not then why ?

21. How can you configure a java ee agent ? Explain.

22. What is internal id in ODI ? Explain.

23. What is sunopsis memory engine ?

24. Can we create multiple local agent ? If yes then how ?

25. What are the different strategy for promoting a project from one env to other env.

26. What are the minimum things required to take master and work repository backup.

27. Is it necessary to have a key in interface. Explain your answer.

28. How to create agent as a service in 10 and 11g version.

29. What are the known bugs of ODI you have listened ?

30. What is the oracle forum id of oracle data integrator?

31. How do you create different user for ODI login. What are the different profile

available ? Explain.

32. What do you mean by webservice ? How ODI support web services ?

33. What is ODI console and EM ?

34. How ODI is different than OWB ?

35. How can you send authenticated emails in ODI.

36. What are the different temporary tables created in ODI ?

37. How can you handles when multiples interfaces loading to a same table ?

38. What is substitution api ? How to get the error message using substitution api ?

39. What do you know about ODI SDK. What is the use of ODI SDK ?

40. What technology you will chose to process mdb files ?

Similer Documents