Interview Questions.

Q1. How To Handle Exceptions?

Exceptions In packages superior tab and load plan exception tab we are able to cope with exceptions.

Q2. What Is Profile In Odi?

Profile is a set of goal wise privileges. We will assign this profiles to the users. Users gets the privileges from profile.

Q3. How To Reverse Engineer Views(how To Load The Data From Views)?

In Models Go to Reverse engineering tab and choose Reverse engineering item as VIEW.

Q4. What Are Knowledge Modules?

Knowledge Modules shape the premise of ‘plug-ins’ that allow ODI to generate the relevant execution code , throughout technology , to carry out responsibilities in considered one of six areas, the six sorts of information module include: 

Reverse-engineering know-how modules are used for reading the table and different object metadata from source databases

Journalizing expertise modules record the brand new and modified statistics within both a unmarried table or view or a regular set of tables or views

Loading information modules are used for green extraction of statistics from source databases for loading into a staging vicinity (database-unique bulk sell off utilities may be used in which to be had)

Check information modules are used for detecting errors in source statistics

Integration knowledge modules are used for correctly trforming statistics from staging location to the goal tables, generating the optimized local SQL for the given database

Service information modules provide the ability to show data as Web services

ODI ships with many expertise modules out of the box, those also are extendable, they are able to modified in the ODI Designer module.

Q5. Can We Implement Package In Package?

Yes, we will name one package into other bundle.

Q6. What Is The Odi Console?

ODI console is an internet primarily based navigator to get right of entry to the Designer, Operator and Topology components thru browser.

Q7. What Is Oracle Data Integration Suite?

Oracle data integration suite is a fixed of data control applications for constructing, deploying, and coping with corporation records integration solutions:

Oracle Data Integrator Enterprise Edition

Oracle Data Relationship Management

Oracle Service Bus (limited use)

Oracle BPEL (restricted use)

Oracle WebLogic Server (restrained use)

Additional product options are:

Oracle Goldengate

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

Oracle Data Profiling (Trillium based Data Profiling)

ODSI (the previous Aqualogic Data Services Platform)

Q8. What Systems Can Odi Extract And Load Data Into?

ODI brings actual 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 assisting JDBC, its viable even to apply the Oracle BI Server as a information supply using the jdbc driving force that ships with BI Publisher.

Q9. What Is Load Pl And Types Of Load Pl?

Load plan is a system to run or execute more than one scenarios as a Sequential or parallel or conditional based totally execution of your situations. And equal we are able to call 3 styles of load pl , Sequential, parallel and Condition based totally load pl.

Q10. If The Source And Target Are Oracle Technology Tell Me The Process To Achieve This Requirement(interfaces, Kms, Models)

Use LKM-SQL to SQL or LKM-SQL to Oracle , IKM Oracle Incremental update or Control append.

Q11. What Components Make Up Oracle Data Integrator?

“Oracle Data Integrator” incorporates of:

1) Oracle Data Integrator + Topology Manager + Designer + Operator + Agent

2) Oracle Data Quality for Data Integrator

three) Oracle Data Profiling

Q12. Explain What Is Odi?Why Is It Different From The Other Etl Tools.

ODI stands for Oracle Data Integrator. It is different from another ETL tool in a manner that it uses E-LT method as opposed to ETL method. This technique removes the need of the special Trformation Server among the Source and Target Data server. The strength of the goal information server may be used to trform the records. I.E. The target facts server acts as staging region similarly to its function of goal databasel. While loading the information within the goal database (from staging place) the trformation logic is applied. Also, the use of suitable CKM (Check Knowldege Module) may be made while doing this to put in force records first-class requirement.

Q13. Suppose Having Unique And Duplicate But I Want To Load Unique Record One Table And Duplicates One Table?

Create  interfaces or once system and use two queries one for Unique values and one for duplicate values.

Q14. What Is Oracle Data Integrator (odi)?

Oracle obtained Sunopsis in 2006 and with it “Sunopsis Data Integrator”.

Oracle Data Integrator (ODI) is an E-LT (Extract, Load and Trform) tool used for excessive-pace records movement between disparate systems.

The cutting-edge version, Oracle Data Integrator Enterprise Edition (ODI-EE) brings collectively “Oracle Data Integrator” and “Oracle Warehouse Builder” as separate components of a unmarried product with a unmarried licence.

Q15. How To Implement The Logic In Procedures If The Source Side Data Deleted That Will Reflect The Target Side Table?

User this query on Command on target Delete from Target_table in which now not exists (Select ‘X’ From Source_table Where Source_table.ID=Target_table.ID).

Q16. Does My Odi Infrastructure Require An Oracle Database?

No, the ODI modular repositories (Master + and certainly one of multiple Work repositories) can be mounted on any database engine that helps ANSI ISO 89 syntax along with Oracle, Microsoft SQL Server, Sybase AS Enterprise, IBM DB2 UDB, IBM DB2/forty.

Q17. What Is E-lt?

E-LT is an innovative technique to extracting, loading and Trforming data. Typically ETL software companies have relied on highly-priced heavyweight , mid-tier server to perform the trformations required while shifting large volumes of statistics around the company.

ODI grants specific next-generation, Extract Load and Trform (E-LT) era that improves overall performance and reduces facts integration charges, even throughout heterogeneous structures by way of pushing the processing required down to the typically big and powerful database servers already in location within the organization.

Q18. How Will You Bulk Load Data?

In Odi there are IKM which are designed for bulk loading of information.

Q19. How Will You Bring In The Different Source Data Into Odi?

You may have to create dataservers within the topology supervisor for the unique assets that you need.

Q20. How Will You Bring In Files From Remote Locations?

We will invoke the Service understanding module in ODI,this will assist us to accesses statistics notion a web provider.

Q21. How Will You Handle Data Quality In Odi?

There are two ways of dealing with facts nice in Odi….The primary method offers with handling the incorrect facts the usage of the CKM…the second approach makes use of Oracle facts high-quality device(this is for advanced fine options)

Q22. Is Odi Used By Oracle In Their Products?

Yes there are many Oracle merchandise that utilise ODI, but right here are only some:

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 additionally makes use of ODI as its middle ETL tool in vicinity of Informatica , however best for one release of OBIA and when the usage of a positive supply system.

Q23. Does Odi Support Web Services?

Yes, ODI is ‘SOA’ enabled and its net offerings may be utilized in three methods:

The Oracle Data Integrator Public Web Service, that helps you to execute a situation (a posted package) from an internet service call

Data Services, which offer an internet provider over an ODI records store (i.E. A desk, view or different data source registered in ODI)

The ODIInvokeWebService device that you may upload to a package to request a reaction from a web provider.

Q24. In The Package One Interface Got Failed How To Know Which Interface Got Failed If We No Access To Operator?

Make it mail alert or take a look at into SNP_SESS_LOg tables for consultation log details.

Q25. How To Load The Data With One Flat File And One Rdbms Table Using Joins?

Drag and drop each File and table into supply vicinity and join as in Staging location.

Q26. How To Implement Data Validations?

Use Filters & Mapping Area AND Data Quality related to constraints use CKM Flowcontrol.

Q27. If The Source Have Total 15 Records With 2 Records Are Updated And 3 Records Are Newly Inserted At The Target Side We Have To Load The Newly Changed And Inserted Records

Use IKM Incremental Update Knowledge Module for Both Insert n Update operations.

Q28. How To Remove The Duplicate In Odi?

Use DISTINCT in IKM degree. It's going to put off the replica rows whilst loading into goal.

Q29. How To Write The Sub-queries In Odi?

Using Yellow interface and sub queries option we will create sub queries in ODI. Or Using  VIEW we will move for sub queries Or Using ODI Procedure we are able to name direct database queries in ODI.

Q30. What Is A Procedure And How To Write The Procedures In Odi?

A Procedure is a reusable issue that permits you to institution moves that don't suit in the Interface framework. (That is load a target datastore from one or more assets). A Procedure is a sequence of commands launched on logical schemas. It has a set of associated alternatives. These options parameterize whether or not or no longer a command need to be achieved in addition to the code of the commands.

Q31. Suppose I Having 6 Interfaces And Running The Interface three Rd One Failed How To Run Remaining Interfaces?

If you are running Sequential load it'll forestall the opposite interfaces. So goto operator and proper click on on filed interface and click on on restart. If you are going for walks all the interfaces are parallel only one interface will fail and other interfaces will finish.