ODI interview questions:
1. What is Oracle Data Integrator ?
2. Can we call ODI as a ETL tool. If yes then How ?
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 ?
I will append more questions as soon as i can.