Recent Articles

Video: Converting FpML XML to Snowflake

https://youtu.be/8l3G-xdMQcU
Uli Bethke October 23, 2020

Snowflake date and time dimension

Here is a simple SQL script that will generate a date dimension in Snowflake. We are using the built-in GENERATOR and SEQ function. Start date for the dimension is 2017-01-01.…
Uli Bethke January 28, 2019

Dimensional Modeling and Kimball Data Marts in the Age of Big Data and Hadoop

The purpose of this article is threefold (1) Show that we will always need a data model (either done by humans or machines) (2) Show that physical modelling is not…
Uli Bethke May 15, 2017

Automating XML Conversion with Oracle's ETL Tool ODI

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and RecipesIn the previous posts we demonstrated how Flexter liberates data from complex…
Uli Bethke February 10, 2017

ODI 11g Repository Book Out Now

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes The book is for free. All you need to do is contact us. We will…
Uli Bethke December 12, 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
spinner