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

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 [wpcode id="26679"] ODI and Jetty The ODI 11g standalone agent now…
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

How to query a whole schema or even database?! This tip will save you hours and hours of boring work.

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes I really like this tip especially its simplicity. It has saved…
Uli Bethke October 22, 2012
spinner