ODI Interview Questions

These are some of the basic questions u might need to know if you are a beginner to ODI

Q1.Explain what is ODI?why is it different from the other ETL tools.

ANS: ODI stands for Oracle Data Integrator. It is different from another ETL tool in a way that it uses E-LT approach as opposed to ETL approach. This approach eliminates the need of the exclusive Transformation Server between the Source and Target Data server. The power of the target data server can be used to transform the data. i.e. The target data server acts as staging area in addition to its role of target databasel. While loading the data in the target database (from staging area) the transformation logic is implemented. Also, the use of appropriate CKM (Check Knowldege Module) can be made while doing this to implement data quality requirement.

Q2.Explain about what you have done using ODI?

Q3.How will you bring in the different source data into ODI?

ANS:you will have to create dataservers in the topology manager for the different sources that you want.

Q4.How will you bulk load data?

ANS:In Odi there are IKM that are designed for bulk loading of data.

Q5.How will you install ODI?

ANS:http://odi-consulting.blogspot.com/2011/10/oracle-data-integrator-odisunopsis.html

Q6.How will you bring in files from remote locations?

ANS:We will invoke the Service knowledge module in ODI,this will help us to accesses data thought a web service.

Q7.How will you handle dataquality in ODI?

ANS:There are two ways of handling dataquality in Odi....the first method deals with handling the incorrect data using the CKM...the second method uses Oracle data quality tool(this is for advanced quality options)