TalentpoolTech

01/03/2017

Hi Guys, Welcome back to my blog after a long time!! Today I am gonna teach you some interesting topic which is mainly useful for the guys who are working as ODI Admin. Generally in ODI SUPERVISOR …

13/07/2016

How to get DDL of a table ?

Hi Guys, Today I came up with one interesting thing doing some research on Database. At the time of research I stopped by a silly question but some what it’s very important to know.If somebod…

05/07/2016

Unable to create an instance of the Java Virtual Machine

Hi Friends, Welcome to my blog after a long time. Yesterday night I did ODI 12.2.1 installation in Windows 7.The installation went smoothly  without any error.So immediately I thought to open ODI s…

05/07/2016

How to change the JDK version of ODI Studio?

For ODI 12c : Navigate to “C:\Users\vamrutha\AppData\Roaming\odi\1.0.0.0.0” location on WINDOWS navigate to “C:\Documents and Settings\exampleuser\Datos de programa\odi\1.0.0.0.0&…

08/06/2016

How to display “nth” highest salary by deptno wise?

Hi Guys Good evening, Welcome back to my blog once again. Today I am gonna explain how to retrieve  “nth” highest salary by deptno wise?. Here is my answer: select rnk,deptno,max(sal) f…

05/06/2016

How to implement Group By and Having clause in ODI?

Hi folks, welcome back to my blog once again after a long vacation!!!!!! Really sorry for the delay. To day I am gonna explain one requirement asked by one of my blog follower in detail how to impl…

26/04/2016

What is in the Topology?

Hi Friends, Good morning ! welcome back to my blog. In this post I planned to discuss what is topology? what is there in the topology?? As said in my earlier post in ODI studio Topology Navigator i…

22/04/2016

Hi All, I am back once again with an interesting topic called RECYCLE ERROR. generally whenever we ask people in our casual discussion what is recycle error people will say it re-loads data from er…

22/04/2016

Nope, it doesn’t update the second record because update of the existing record from ODI will be done using ROWID. Thanks Venkatesh

22/04/2016

HI Friends, I am back with another unknown error for all of you. When ever we try to use IKM Oracle Incremental Update (row by row) we will be getting subject error. if you haven’t used this …

22/04/2016

IKM Oracle Incremental Update : it performs all inserts, updates and individually however it will be slower since it needs to compare values source vs target where update key’s will match.Not…

22/04/2016

Hi Al, after a long time coming back with small question but interesting one. whenever there is a session been executed in ODI it generates command on source and command on target. once the session…