Wednesday, 5 March 2014

Oracle Data Integrator(ODI) Concepts ..!!!


Qs> What is Oracle Data Integrator (ODI)?
Oracle acquired Sunopsis in 2006 and with it “Sunopsis Data Integrator”.
Oracle Data Integrator (ODI) is an E-LT (Extract, Load and Transform) tool used for high-speed data movement between disparate systems.
The latest version, Oracle Data Integrator Enterprise Edition (ODI-EE) brings together “Oracle Data Integrator” and “Oracle Warehouse Builder” as separate components of a single product with a single licence.
Qs> What is E-LT?
E-LT is an innovative approach to extracting, loading and Transforming data. Typically ETL application vendors have relied on costly heavyweight , mid-tier server to perform the transformations required when moving large volumes of data around the enterprise.
ODI delivers unique next-generation, Extract Load and Transform (E-LT) technology that improves performance and reduces data integration costs, even across heterogeneous systems by pushing the processing required down to the typically large and powerful database servers already in place within the enterprise.
Qs> What components make up Oracle Data Integrator?
“Oracle Data Integrator” comprises of:
- Oracle Data Integrator + Topology Manager + Designer + Operator + Agent
- Oracle Data Quality for Data Integrator
- Oracle Data Profiling

Qs> What is Oracle Data Integration Suite?

Oracle data integration suite is a set of data management applications for building, deploying, and managing enterprise data integration solutions:
Oracle Data Integrator Enterprise Edition
Oracle Data Relationship Management
Oracle Service Bus (limited use)
Oracle BPEL (limited use)
Oracle WebLogic Server (limited use)
Additional product options are:
Oracle Goldengate
Oracle Data Quality for Oracle Data Integrator (Trillium-based DQ)
Oracle Data Profiling (Trillium based Data Profiling)
ODSI (the former Aqualogic Data Services Platform)

Qs> What systems can ODI extract and load data into?

ODI brings true 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 supporting JDBC, its possible even to use the Oracle BI Server as a data source using the jdbc driver that ships with BI Publisher
Qs> What are Knowledge Modules?
Knowledge Modules form the basis of ‘plug-ins’ that allow ODI to generate the relevant execution code , across technologies , to perform tasks in one of six areas, the six types of knowledge module consist of:
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)
Check knowledge modules are used for detecting errors in source data
Integration knowledge modules are used for efficiently transforming data from staging area to the target tables, generating the optimized native SQL for the given database
Service knowledge modules provide the ability to expose data as Web services
ODI ships with many knowledge modules out of the box, these are also extendable, they can modified within the ODI Designer module.

Qs> How do ‘Contexts’ work in ODI?
ODI offers a unique design approach through use of Contexts and Logical schemas. Imagine a development team, within the ODI Topology manager a senior developer can define the system architecture, connections, databases, data servers (tables etc) and so forth.
These objects are linked through contexts to ‘logical’ architecture objects that are then used by other developers to simply create interfaces using these logical objects, at run-time, on specification of a context within which to execute the interfaces, ODI will use the correct physical connections, databases + tables (source + target) linked the logical objects being used in those interfaces as defined within the environment Topology.
Qs> Does my ODI infrastructure require an Oracle database?
No, the ODI modular repositories (Master + and one of multiple Work repositories) can be installed on any database engine that supports ANSI ISO 89 syntax such as Oracle, Microsoft SQL Server, Sybase AS Enterprise, IBM DB2 UDB, IBM DB2/40.
Qs> Does ODI support web services?
Yes, ODI is ‘SOA’ enabled and its web services can be used in 3 ways:
The Oracle Data Integrator Public Web Service, that lets you execute a scenario (a published package) from a web service call
Data Services, which provide a web service over an ODI data store (i.e. a table, view or other data source registered in ODI)
The ODIInvokeWebService tool that you can add to a package to request a response from a web service
Qs> Is ODI Used by Oracle in their products?
Yes there are many Oracle products that utilise ODI, but here are just a few:
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 also uses ODI as its core ETL tool in place of Informatica , but only for one release of OBIA and when using a certain source system.


•The ability to dynamically manage a staging area
•The ability to generate code on source and target systems alike, in the same transformation
•The ability to generate native SQL for any database on the market—most ETL tools will generate code for their own engines, and then translate that code for the databases—hence limiting their generation capacities to their ability to convert proprietary concepts

•The ability to generate DML and DDL, and to orchestrate sequences of operations on the heterogeneous systems

1.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.

2.Explain about what you have done using ODI?


3.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.

4.How will you bulk load data?

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

5.How will you install ODI?


6.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.

7.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)

8. what is load plans and types of load plans?
ANS) Load plan is a process to run or execute multiple scenarios as a Sequential or parallel or conditional based execution of your scenarios. And same we can call three types of load plans , Sequential, parallel and Condition based load plans. 
9. what is profile in odi?
ANS)  profile is a set of objective wise privileges. we can assign this profiles to the users. Users will get the privileges from profile. Please refer http://oditraining.blogspot.co.uk/2012/06/odi-security-manager-all-profiles.html


10 what is the odi console?
ANS) ODI console is a web based navigator to access the Designer, Operator and Topology components through browser. 

11.how to write the sub queries in odi?
ANS:)Using Yellow interface and sub queries option we can create sub queries in odi.
or Using  VIEW we can go for sub queries Or Using ODI Procedure we can call direct DB queries
in ODI.

12.suppose i having 6 interfaces and running the interface 3 rd one failed how to run remaining interfaces?
ANS: ) if you are running Sequential load it will stop the other interfaces. so goto operator and right click on filed interface and click on restart. If you are running all the interfaces are parallel only one interface will fail and other interfaces will finish. 

13. how to remove the duplicate in odi?
ANS) Use DISTINCT in IKM level. it will remove the duplicate rows while loading into target. 

14. suppose having unique and duplicate but i want to load unique record one table and duplicates one table?
ANS) Create two interfaces or once procedure and use two queries one for Unique values and one for duplicate values. 

15. how to write the procedures in odi?
ANS) Procedure is a step by step any technology code operations . you can refer 

98 comments:

  1. Hi,
    You have provided Best Interview Questions and information for ODI.it is very usefull to readers who want Data integration platform.Keen Technologies offers in-depth Online Training for Oracle Data Integrator(ODI) in module of Oracle. Our response is almost immediate and we offer you the freedom to cut down on your training costs and ramp-up your resources where needed in minimal time.

    ReplyDelete
  2. https://www.google.co.in/url?sa=t&rct=j&q=&esrc=s&source=web&cd=3&cad=rja&uact=8&ved=0CCoQtwIwAg&url=http%3A%2F%2Fwww.youtube.com%2Fwatch%3Fv%3DPXsI991kyOQ&ei=HSadVOelONCyuQSVhIK4CQ&usg=AFQjCNGYVrXF1RZYY2AWvMfKTeer-3Xoqw&bvm=bv.82001339,d.c2E

    ReplyDelete
  3. Thanks for sharing useful information about Oracle Data Integrator Interview Questions and refer the link Android Training in Chennai

    ReplyDelete
  4. how is demand for odi in market at presant

    ReplyDelete
  5. This information is impressive; I am inspired with your post writing style & how continuously you describe this topic. After reading your post, thanks for taking the time to discuss this, I feel happy about it and I love learning more about this topic.
    Regards,
    Salesforce training in Chennai|Salesforce training institute in Chennai|Salesforce course in Chennai

    ReplyDelete
  6. I was looking about the Oracle Training in Chennai for something like this,Thank you for posting the great content..I found it quiet interesting, hopefully you will keep posting such blogs…
    Greens Technologies In Chennai

    ReplyDelete
  7. Greens Technology offer a wide range of training from ASP.NET , SharePoint, Cognos, OBIEE, Websphere, Oracle, DataStage, Datawarehousing, Tibco, SAS, Sap- all Modules, Database Administration, Java and Core Java, C#, VB.NET, SQL Server and Informatica, Bigdata, Unix Shell, Perl scripting, SalesForce , RedHat Linux and Many more.

    ReplyDelete
  8. Thank you for sharing this knowledge in a blogpost.Really simple and even more effective and this worked great, very useful tips
    sas online training

    ReplyDelete
  9. Pretty article! I found some useful information in your blog, it was awesome to read, thanks for sharing this great content to my vision, keep sharing..
    soa training in chennai

    ReplyDelete
  10. TANGEDCO Recruitment 2016 AE Technical Field Assistant Typist

    Thanks for sharing with us that awesome article you have amazing blog.........

    ReplyDelete
  11. BHEL Bhopal Apprentice Recruitment 2016

    Very nice post.......... Keep sharing this kind of posts....

    ReplyDelete
  12. Great post and informative blog.it was awesome to read, thanks for sharing this great content to my vision.
    Informatica Training In Chennai
    Hadoop Training In Chennai
    Oracle Training In Chennai
    SAS Training In Chennai

    ReplyDelete
  13. I find the required information on Oracle ODI. Thanks for providing your information on
    Oracle ODI online training.

    ReplyDelete
  14. Oracle Data Integrator is a comprehensive data integration platform for all data integration requirements — from high-volume, high-performance batches, Surya Informatics Industrial

    ReplyDelete
  15. I'm looking for some scenario based real world questions on ODI. can you please mail it to me.

    ReplyDelete
  16. Thanks for the interview Questions, We also provide Oracle Data Integrator (ODI) Interview Questions.check this site Tekslate for more Oracle Data Integrator (ODI) Interview Questions.

    ReplyDelete
  17. Thanks for posting useful information.You have provided an nice article, Thank you very much for this one. And i hope this will be useful for many people.. and i am waiting for your next post keep on updating these kinds of knowledgeable things...Really it was an awesome article...very interesting to read..please sharing like this information......
    Web Design Development Company
    Mobile App Development Company


    ReplyDelete

  18. Nice tutorial. The ODI tutorial was help ful for me. Keep Sharing Tutorials.

    ReplyDelete
  19. Your very own commitment to getting the message throughout came to be rather powerful and have consistently enabled employees just like me to arrive at their desired goals.
    Click here:
    angularjs training in velarchery
    Click here:
    angularjs training in sholinganallur
    Click here:
    angularjs training in btm

    ReplyDelete
  20. Really you have done great job,There are may person searching about that now they will find enough resources by your post
    Blue Prism Training in Pune

    Blueprism training in tambaram

    Blueprism training in annanagar

    ReplyDelete
  21. Thanks you for sharing this unique useful information content with us. Really awesome work. keep on blogging

    DevOps online Training|DevOps Training in USA

    ReplyDelete
  22. Appreciating the persistence, you put into your blog and detailed information you provide.
    safety courses in chennai

    ReplyDelete
  23. Great Article… I love to read your articles because your writing style is too good, its is very very helpful for all of us and I never get bored while reading your article because, they are becomes a more and more interesting from the starting lines until the end.
    Etl Testing Training From India

    ReplyDelete
  24. Thanks you for sharing this unique useful information content with us. Really awesome work. keep on blogging
    Selenium Training From India

    ReplyDelete
  25. This article is very much helpful and i hope this will be an useful information for the needed one. Keep on updating these kinds of informative things...
    Oracle Rac Online Training

    ReplyDelete
  26. great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome...Thank you very much for this one.
    Oracle SOA Online Training

    ReplyDelete
  27. I have read a few of the articles on your website now, and I really like your style of blogging. I added it to my favourites blog site list and will be checking back soon.

    java training in annanagar | java training in chennai

    java training in chennai | java training in electronic city

    ReplyDelete
  28. Thanks for such a great article here. I was searching for something like this for quite a long time and at last I’ve found it on your blog. It was definitely interesting for me to read  about their market situation nowadays.
    Data Science Course in Indira nagar
    Data Science Course in Electronic city
    Python course in Kalyan nagar
    Data Science course in Indira nagar

    ReplyDelete
  29. Greetings! Very helpful advice within this article! It’s the little changes that produce the biggest changes. Thanks for sharing!
    Dotnet Training institute

    PHP Training institute

    Qlikview Training institute

    r-programming Training institute

    ReplyDelete
  30. good work done and keep update more.i like your information's and
    that is very much useful for readers.
    python training institutes in bangalore
    python institutes in bangalore
    Python Courses in T nagar

    ReplyDelete
  31. I am happy to find this post Very useful for me, as it contains lot of information

    Article submission sites
    Guest posting sites

    ReplyDelete
  32. Amazing article. Your blog helped me to improve myself in many ways thanks for sharing this kind of wonderful informative blogs in live. I have bookmarked more article from this website. Such a nice blog you are providing ! Kindly Visit Us R Programming institutes in Chennai | R Programming Training in Chennai | R Programming Course Fees

    ReplyDelete

  33. Great efforts put it to find the list of articles which is very useful to know, Definitely will share the same to other forums. hadoop training in chennai velachery | hadoop training course fees in chennai | Hadoop Training in Chennai Omr

    ReplyDelete
  34. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.
    rpa training in bangalore
    rpa training in pune
    rpa training in marathahalli
    rpa training in btm

    ReplyDelete
  35. Inspiring writings and I greatly admired what you have to say , I hope you continue to provide new ideas for us all and greetings success always for you..Keep update more information.


    rpa training in chennai |
    best rpa training in chennai
    rpa online training
    rpa course in bangalore
    rpa training in pune
    rpa training in marathahalli
    rpa training in btm

    ReplyDelete
  36. I appreciate that you produced this wonderful article to help us get more knowledge about this topic. I know, it is not an easy task to write such a big article in one day, I've tried that and I've failed. But, here you are, trying the big task and finishing it off and getting good comments and ratings. That is one hell of a job done!
    python training in chennai | python course institute in chennai

    ReplyDelete
  37. This comment has been removed by the author.

    ReplyDelete

  38. This is most informative and also this post most user friendly and super navigation to all posts... Thank you so much for giving this information to me.

    best rpa training in chennai
    rpa training in chennai |
    rpa online training
    rpa course in bangalore
    rpa training in pune
    rpa training in marathahalli
    rpa training in btm

    ReplyDelete
  39. This is a good post. This post give truly quality information. I’m definitely going to look into it. Really very useful tips are provided here. thank you so much. Keep up the good works.
    Java training in Chennai | Java training in Bangalore

    Java online training | Java training in Pune

    ReplyDelete
  40. This comment has been removed by the author.

    ReplyDelete
  41. Nice information, valuable and excellent design, as share good stuff with good ideas and concepts, lots of great information and inspiration, both of which I need, thanks to offer such a helpful information here.
    aws Training in indira nagar

    selenium Training in indira nagar

    python Training in indira nagar

    datascience Training in indira nagar

    devops Training in indira nagar

    ReplyDelete
  42. You’ve got an awful lot of text for only having one or 2 pictures. Maybe you could space it out better?
    fire and safety course in chennai

    ReplyDelete
  43. Useful content, I have bookmarked this page for my future reference.
    Devops Training in Chennai | Devops Training Institute in Chennai

    ReplyDelete
  44. This software of QuickBooks Payroll Support Phone Number comes with various versions and sub versions. Online Payroll and Payroll for Desktop may be the two major versions and they're further bifurcated into sub versions. Enhanced Payroll and Full-service payroll are encompassed in Online Payroll whereas Basic, Enhanced and Assisted Payroll come under Payroll for Desktop

    ReplyDelete
  45. This comment has been removed by the author.

    ReplyDelete
  46. This comment has been removed by the author.

    ReplyDelete
  47. This comment has been removed by the author.

    ReplyDelete
  48. It is simple to reach our staff via QuickBooks Tech Support get required suggestion after all time. The group sitting aside understands its responsibility as genuine & offers reasonable assistance with your demand.

    ReplyDelete
  49. Welcome aboard, to your support site par excellence where all your worries related to the functioning of QuickBooks Enterprise Tech Support Number will be addressed by our world-class team of QuickBooks Enterprise Support once you go through the blink of a wrist watch. If you're experiencing any hiccups in running the Enterprise type of the QuickBooks software for your requirements, a good idea is not to ever waste another second in trying to find an answer for the problems.

    ReplyDelete
  50. If that's so, Quickbooks online payroll support number provides 24/7 make it possible to our customer. Only you need to do is make an individual call at our toll-free QuickBooks Technical Support Phone Number .

    ReplyDelete
  51. QuickBooks Online Payroll Contact Number
    So so now you are becoming well tuned directly into advantages of QuickBooks online payroll in your business accounting but because this premium software contains advanced functions that will help you and your accounting task to accomplish, so you could face some technical errors when using the QuickBooks payroll solution. In that case, Quickbooks online payroll support number provides 24/7 make it possible to our customer. Only you must do is make a person call at our toll-free QuickBooks Payroll tech support number . You could get resolve most of the major issues include installations problem, data access issue, printing related issue, software setup, server not responding error etc with this QuickBooks payroll support team.

    ReplyDelete
  52. The QuickBooks 24/7 Payroll Support Phone Number USA team at site name is held accountable for removing the errors that pop up in this desirable software. We take care of not letting any issue can be found in between your work and trouble you in undergoing your tasks. Most of us resolves all of the QuickBooks Payroll issue this type of a fashion you will yourself believe that your issue is resolved without you wasting the full time into it.

    ReplyDelete
  53. Welcome aboard, to your support site par excellence where your entire worries linked to the functioning of QuickBooks Enterprise may be addressed by our world-class team of QuickBooks Enterprise Tech Support within the blink of an eye. If you are experiencing any hiccups in running the Enterprise version of the QuickBooks software for your needs, a good idea is never to waste another second in trying to find an answer for the problems.

    ReplyDelete
  54. The net is stuffed with faux numbers WHO decision themselves the QuickBooks Support Provider. you’ll value more highly to dial their variety however that might be terribly risky. you’ll lose your QuickBooks Company file or the code itself. dig recommends dialing solely the authentic QuickBooks Support Number.

    ReplyDelete
  55. Sales personal will generate customer invoices, Vendor developer will appear into vendor creation and payments and finance managers will be needing financial decisions taking a look at the financial reports of QuickBooks Enterprise Support Number.

    ReplyDelete
  56. QuickBooks Help & Support is engaged in pre-research to create themselves prepared in advance for the possible errors of QuickBooks. This practice helps them produce you the specified wind up in the given time window. We are there to assist you 24*7 as we try not to disassociate ourselves together with your troubles even through the wee hours.

    ReplyDelete
  57. There are many features that produce QuickBooks Technical Support such as for instance it gives bank security that aids you to go with IT maintenance smoothly. You can also add amount of users that will access company files at multiple locations. It gives you the facility of automated data backup and recovery.

    ReplyDelete
  58. QuickBooks Support Phone Number functions: A business must notice salaries, wages, incentives, commissions, etc., it has paid to your employees in an occasion period. Most of all is the tax calculations must be correct and in line with the federal and state law.

    ReplyDelete
  59. Issues like these and all the other complex ones are particularly easily resolved by our team at QuickBooks Tech Support Phone Number Our customer support executives are experienced, talented, hardworking a simple yet effective. They put their hundred percent efforts and make certain to have you avail their 24*7 assistance. Call us at our toll-free number or drop us a mail.

    ReplyDelete
  60. The toll-free QuickBooks Tech Support Phone Number can be reached 24/7 to get in touch with the executives who will be taught to assist you to fix any type of QuickBooks related issues.

    ReplyDelete
  61. We now have a technique of deleting the power which you have put immediately from our storage. Thus, there isn't any possibility for data getting violated. You need to get to us when it comes to a number of software issues. The QuickBooks Support Phone Number satisfaction may be high class with us.

    ReplyDelete

  62. Quickbooks Support Number could be contacted to master the ways to generate an automatic backup to save your entire employee-related data from getting bugged or lost at any circumstances.

    ReplyDelete
  63. we now have a tendency to rank our customers over something and therefore we try to offer you a swish accounting and management expertise. you’ll additionally visit our web site to induce to understand additional concerning our code and its upgrades. you’ll scan in-depth articles concerning most of the errors and also how you can resolve them. Rectifying errors desires in-depth information regarding the device as well as its intricacies. Our QuickBooks Support Phone Number can be a go-to supply for everything associated with QuickBooks.

    ReplyDelete
  64. The Premier support is provided by technicians who are trained from time to time to meet up with any kind of queries related to integrating QuicKbooks Customer Support Phone Number with Microsoft Office related software.

    ReplyDelete
  65. Collaborate with colleagues:- QuickBooks’ cloud-based software allows your bookkeeper, accountant, or colleagues, to log in simultaneously and work directly with your data online. Securely access your data:- QuickBooks Support Number always uses advanced, industry-recognized security safeguards that are going to maintain your data protected. Above all your computer data can automatically back up.

    ReplyDelete

  66. You are always able to relate to us at our QuickBooks Technical Support Phone Number to extract the finest support services from our highly dedicated and supportive QuickBooks Support executives at any point of time as all of us is oftentimes ready to make use of you.

    ReplyDelete
  67. I wish to show thanks to you just for bailing me out of this particular trouble.As a result of checking through the net and meeting techniques that were not productive, I thought my life was done.

    Best PHP Training Institute in Chennai|PHP Course in chennai
    Best .Net Training Institute in Chennai
    Dotnet Training in Chennai
    Dotnet Training in Chennai

    ReplyDelete
  68. We have been certain to assist you with your account related queries and more. The pro advisor has completed professional training and it has experience in accountancy. If you would like to learn how to Resolve Quickbooks Error 9999, you can continue reading this blog.

    ReplyDelete
  69. Great post!I am actually getting ready to across this information,i am very happy to this commands.Also great blog here with all of the valuable information you have.Well done,its a great knowledge keep it up guys
    Ai & Artificial Intelligence Course in Chennai
    PHP Training in Chennai
    Ethical Hacking Course in Chennai Blue Prism Training in Chennai
    UiPath Training in Chennai

    ReplyDelete
  70. It is really wonderful and awesome thus it is very much useful for me to understand many concepts and helped me a lot. It is really explainable very well and i got more information from your blog. Please, continue to give me such valuable posts.
    Data Science Training In Chennai

    Data Science Online Training In Chennai

    Data Science Training In Bangalore

    Data Science Training In Hyderabad

    Data Science Training In Coimbatore

    Data Science Training

    Data Science Online Training

    ReplyDelete

  71. Thanks for the nice blog here.I was searching this one for a long time.This blog is very helpful for my studies..I got another one site also,which is same as yours Oracle ODI .Check this one also Oracle Fusion Manufacturing .Sure it will be helpful for you too..Once more iam thanking you for your creative blog.

    ReplyDelete
  72. Are you interested in doing Data Science Course in Chennai with a Certification Exam? Catch the best features of Data Science training courses with Infycle Technologies, the best Data Science Training & Placement institutes in and around Chennai. Infycle offers the best hands-on training to the students with the revised curriculum to enhance their knowledge. In addition to the Certification & Training, Infycle offers placement classes for personality tests, interview preparation, and mock interviews for clearing the interviews with the best records. To have all it in your hands, dial 7504633633 for a free demo from the experts.
    Grab Data Science Course in Chennai | Infycle Technologies

    ReplyDelete