Executing Interfaces and Procedures in parallel in a Package with ODI

Uli Bethke Oracle Data Integrator (ODI)

I have been working on Oracle Data Integrator (ODI) over the last three weeks. It is an extremely flexible and innovative tool. Claims by Oracle that it is up to ten times faster to develop ETL routines in ODI as compared to traditional ETL tools are actually no exaggeration. In this article I will show you how to execute Procedures ...

OUG Ireland BI Special Interest Group launched

Uli Bethke Oracle

At the OUG Ireland 2009 we launched the OUG Ireland Business Intelligence Special Interest Group. All OUG Ireland members are welcome to join. Tony Cassidy from Bearing Point and me will co-chair the SIG. We will hold our first meeting in June or July 09. I will give a presentation on Oracle Data Integrator and how it favourably compares to ...

Query hints in OBIEE

Uli Bethke OBIEE

I have recently come across a post on the OTN forums on how to use hints in OBIEE. OBIEE lets you specify hints in the physical layer on a table by table basis. The problem of the user in the forum was how it is possible to hint the alias of a table in the SQL generated by Answers. This ...