SQL override in ODI for OBIA

Dt: 25 April 2015


Recently  I interviewed for OBIA at one of the reputed firms of the world..
Interestingly this firm has rejected me 4 times now.But I keep going back to prove a point to myself.

The fact that ...everytime they have rejected me, the interview panel was so dumb and asked the most stupid questions... is what irritates me a lot.So I hop in every time they conduct drives to check out what stupid questions they have got this time.


I guess thats enough of complaining  .Lets get back to completing the post.

So the question that this beautiful lady on the panel asked me was something related to ODI.

Can we write custom SQL override queries in ODI like we can do in Informatica source qualifiers ..she asked.
When I said " yes we can"  very confidently she looked almost surprised ,,Her next response being "Are you sure".I told her  "I do not remember the KM property right now but yes we have done this before".

Obviously she must have felt that I have bluffed and must have considered that to be one of the most convincing reasons to reject my candidature for the job.

So here is the proof for all those enlightened OBIA professionals who are new to OBIA with ODI.

You can indeed write query overrides in ODI. However this feature comes along with the OBIA LKMs only.

Note: There is one out of the box KM which ships with ODI which lets you issue SQL against the DB.The name of the LKM is Source as SQL.


Let me know if anyone out there has got more to add to this


Also all the ranting at the start of the post is only in good humor :-) & not meant  to hurt anyone