Top Articles

SQL Visualisation Guide – Query Diagrams, Lineage & ERD

Have you ever inherited the SQL codebase from someone else where it is in a “bit of a mess”? 😁 Sound familiar? Most data engineers and SQL developers have been there including myself—staring at a spaghetti-like web of queries, trying to untangle a chaotic SQL codebase. It’s a common nightmare. Traditionally, you had to fight …

Uli Bethke November 3, 2024

Recent Articles

Using ODI user functions to dynamically inject SQL into Interfaces

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes I’d like to share with you a recipe that demonstrates the…
Uli Bethke May 19, 2013

Extreme re-usability in ODI 11g (I can’t believe I am giving away this trick).

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes Another Christmas and a second baby under my belt it’s time…
Uli Bethke January 7, 2013

How you can launch an ODI scenario through a web service call?

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes ODI and Jetty The ODI 11g standalone agent now ships with…
Uli Bethke December 12, 2012
SQL,

Tricks with SQL: Beware of the Predicate in the Outer Join

Today we will have a look what happens when we place a filter condition into an outer join. We will also have a look at how this compares to placing…
Uli Bethke November 21, 2012

Making use of ODI Flexfields to meet requirements

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes What are ODI Flexfields? In ODI you can create user-defined fields…
Uli Bethke November 12, 2012

ODI Snippets: What is the Optimization Context in ODI?

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes There are a lot of confusing messages out there on what…
Uli Bethke October 30, 2012
spinner