Oracle Data Integrator Interview Questions and Answers

Oracle Data Integrator Interview Questions and Answers

Top Oracle Data Integrator Interview Questions and Answers: Below, we have covered detailed answers to the Oracle Data Integrator Interview Questions Which will be helpful to freshers and experienced Professionals. All the best for your interview Preparation.

 

What is Oracle Data Integrator (ODI)?

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

What is E-LT? Or What is the difference between ODI and other ETL Tools?

What components make up Oracle Data Integrator?

What is Oracle Data Integration Suite?

What systems can ODI extract and load data into?

What are Knowledge Modules?

How do ‘Contexts’ work in ODI?

Does my ODI infrastructure require an Oracle database?

Does ODI support web services?

How to reverse engineer views(how to load the data from views)?

Is ODI Used by Oracle in their products?

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

How will your bulk load data?

How will you bring in files from remote locations?

How will you handle dataquality in ODI?

What is load plans and types of load plans?

What is profile in odi?

How to write the sub queries in odi?

How to write the procedures in odi?

Where we can use variables?

What is Work Repository?

What is Master Repository?

What is a Procedure?

What is Model?

What is a Package?

What is User Parameters?

What is a Project?

What is Folder?

What is Sequence?

What is User Functions?

What is Marker?

What is Scenario?

What is Context?

What is Memos?

What is Sequences?

What is Session?

What is Session Tasks?

Can I create more than one Master Repository in ODI?

What are the types of Knowledge Modules?

What is An Interface?

What is a temporary Interface (Yellow Interface)?

Explain some differences between ODI 10g and ODI 11g?

What is CKM and when we will use this CKM?

What is SKM and when we will use this SKM?

What are the types of data quality control?

What is a constraint?

What is E$ table in ODI?

What is I$ table in ODI?

What is J$ table in ODI?

What is Journalization and why we are using in ODI?

Explain step by step procedure to enable Journalization?

What is the ODI Console?

What’s load plans and types of load plans?

How to write the sub-queries in ODI?

Remove the duplicate in ODI?

How to handle exceptions?

How to implement the logic in procedures if the source side data deleted that will reflect the target side table?

Can we implement package in package?

How to load the data with one flat file and one RDBMS table using joins?

How to reverse engineer views (how to load the data from views)?

What systems can ODI extract and load data into?

What are the prime responsibilities of Data Integration Administrator?