File Name: odi interview questions and answers .zip
Explain what is ODI?
- Oracle Data Integrator (ODI) Interview Questions & Answers
- Oracle Data Integrator Interview Questions
- Oracle Data Integrator Interview Questions
Please share your questions which are not available here so that I will post answers for those questions as well.
Oracle data integration suite is a set of data management applications for building, deploying, and managing enterprise data integration solutions:. 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.
Oracle Data Integrator (ODI) Interview Questions & Answers
Please share your questions which are not available here so that I will post answers for those questions as well. Nice tutorial. The ODI tutorial was help ful for me. Keep Sharing Tutorials. My source is DB2 and target is oracle. The mappings are already done and the data are already imported. Now some new data are inserted in source tables. How to import them??? If I will execute the same mappings again , What will happen???? Plz Suggest.
As per my understanding I think your looking for incremental load. If yes then try to implement CDC otherwise even you can implement truncate load to target table. Good work sir Could you please suggest me how to answer those two questions. Delimited files delimiter as "," then if data itself having , operator then handling those records is challenging. For example: One of the column in your delimited file is Name: and value your getting in the file is "Trinesh,Koduru" handling these types of records is challenging.
Loading data from log file into Database. Why it is challenging means the data in the log file is not straight forward. Implementing SCD type 3. Hi Trinesh, Delimited files delimiter as "," then if data itself having , operator then handling those records is challenging.
Or in interface how to do it sir?? Adv Thanks for your help. Thanks a lot very much for the high quality and results-oriented help. Actually I was looking for the same information on internet for Oracle ODI and came across your blog. I am impressed by the information that you have on this blog. Thanks once more for all the details. ODI Interview Questions. So that we will update the Interview questions] General Questions:. Ans: S. In interface we will have only one target datastore.
Mappings we can have more than one data store i. To perform Incremental and Initial Load we need to create two different interfaces. Ans: They are two types of Repositories 1. Master Repository and 2. Ans: We can have one Master and 'n' Work repositories. But each Work repository should be attach to only one Master Repository. So it reduce cost. Ans: Four Types of Navigators are available. What is significant difference between Physical Schema and Logical Schema?
That means we can reuse same code to pick data from different schema's. Ans: ODI agent is run time component which orchestrates the data integration process. Ans: Contexts bring together components of the physical architecture the real Architecture of the information system with components of the Oracle Data Integrator logical architecture the Architecture on which the user works.
For example, contexts may correspond to different execution environments Development, Test and Production or different execution locations Boston Site, New-York Site, and so forth. Ans:Mappings are the logical and physical organization of your data sources, targets, and the transformations through which the data flows from source to target. We can create and manage mappings using the mapping editor, a new feature of ODI 12c.
Ans:A variable is an object that stores a single value. This value can be a string, a number or a date. The variable value is stored in Oracle Data Integrator. Ans:Knowledge Modules KMs are code templates.
Ans: A Load Plan is an executable object in Oracle Data Integrator that can contain a hierarchy of steps that can be executed conditionally, in parallel or in series. Types of Load Plans. Load Plans. A Load Plan is an executable object in Oracle Data Integrator that can contain a hierarchy of steps that can be executed conditionally, in parallel or in series. There is no native support. Load plans are moved to production as it is.
Packages need to convert into scenario and then promote to production. When we execute package it will create new session and for restart it will override the execute session. Ans: Click Here. How to perform parallel execution and serial execution in packages? Ans: Serial No. Data validation is done after loaded to target table. Data validation is done before loaded to target table. If there is any constraints on Target Data server then we need to disable the constraint before load to avoid failure.
Import and export scenarios b. Smart Import and Smart Export Objects. Ans: a. Ans: Import and Export we usually import or export that particular object or scenario but not the depend objects. This time of migration is recommended for lower environments like DEV,QA where we need to do development.
Ans: Clikc Here. What is approach you will follow? What is the approach you will follow for converting columns into rows? Ans: Using Un-Pivot 5. How to load valid records into one table and invalid records into another table? Ans: Click Here 7. Click Here Difference between case and decode? CASE can work with predicates and searchable subqueries. CASE expects datatype consistency.
Stored procedures. Functions must always return a value. Stored procedures do not have this requirement.
Functions cannot alter data or objects in a server. Stored procedures can alter data and objects in database and server. Both functions and stored procedures can accept parameters. Functions can accept input parameters but can return only a single return value.
Email This BlogThis! Unknown May 15, at PM. Unknown October 16, at PM. Trinesh Koduru October 19, at PM. Unknown November 4, at PM. Unknown November 15, at AM. Srinu Vasu November 29, at AM.
Anonymous March 1, at AM. Unknown March 15, at AM. Unknown April 26, at AM. Unknown July 17, at AM. Trinesh Koduru July 30, at AM. Thirdware Memories July 27, at PM. Thirdware Memories August 6, at PM.
Anonymous August 28, at AM.
Oracle Data Integrator Interview Questions
It can be used to extract data from a variety of data sources relational databases, flat files, etc. ODI can be used to support a variety of data integration projects, including the following:. So it reduce cost. Ans: A repository is a metadata matianance database user or schema. There are two types of repositories. That means we can reuse same code to pick data from different schema's. Ans: ODI agent is run time component which orchestrates the data integration process.
What is Oracle Data Integrator? If yes then How? Is it a ELT tool? What are the new features available in ODI 11g? What is agent in ODI. Differentiate local agent and java ee agent.
Oracle Data Integrator 10g Explain what is ODI? 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. The target data server acts as staging area in addition to its role of target databasel.
ODI Interview Questions. [Note: If you want answer for question which is not here (ODI only) please comment below. So that we will update the Interview.
Oracle Data Integrator Interview Questions
There are a lot of opportunities from many reputed companies in the world. According to research, Oracle Data Integrator has a Positive market share. So, You still have the opportunity to move ahead in your career in Oracle Data Integrator Development. If you want to enrich your career and become a professional in Oracle Data Integrator , then visit Mindmajix - a global online training platform: " ODI Certification Training " This course will help you to achieve excellence in this domain. What is E-LT?
Looking for a bright career in Oracle? To clear any interview, you must prepare well on all concepts of Oracle Data Integrator. To clear all your confusions on the interview questions and answers and also on job roles visit our www. Question 1. What Is Oracle Data Integrator odi?
Oracle Data Integrator Interview Questions and answers? Explain what is ODI? What is E-LT? Components of Oracle Data Integrator?
Деревянные скамьи заполняют вертикальную ось, растянувшись на сто с лишним метров, отделяющих алтарь от основания креста. Слева и справа от алтаря в поперечном нефе расположены исповедальни, священные надгробия и дополнительные места для прихожан. Беккер оказался в центре длинной скамьи в задней части собора. Над головой, в головокружительном пустом пространстве, на потрепанной веревке раскачивалась серебряная курильница размером с холодильник, описывая громадную дугу и источая едва уловимый аромат.
Туда и обратно, - мысленно повторял .