The role of Data Lakes or Staging Areas for Data Warehouse ETL
We were asked recently by a client, about the role of a staging area for ETL processes when loading a Data Warehouse, specifically they wanted to »
Exploring Mapbox integration in OAC 6.2
Live location has increasingly proved important in tracking locations of objects and people in real time, especially during the pandemic when following the spread of Covid-19 »
Text mining in R
As data becomes increasingly available in the world today the need to organise and understand it also increases. Since 80% of data out there is in »
Rittman Mead Sponsor Fastnet Entry 2021 Part 2
It started well… we left the pontoon in strong winds and heavy rain. Before the start of Fastnet everybody has to sail past an entry gate »
Rittman Mead Sponsor Fastnet Entry 2021
Part one. In 2002 my wife Val and I decided to buy our first yacht. We lived in the Brighton so it seemed to make sense. »
Sql2Odi now supports the WITH statement
The Rittman Mead's Sql2Odi tool that converts SQL SELECT statements to ODI Mappings, now supports the SQL WITH statement as well. (For an overview of our »
Joining Data in OAC
One of the new features in OAC 6.0 was Multi Table Datasets, which provides another way to join tables to create a Data Set. We »
Oracle Support Rewards
First of all, what is it? Essentially, it’s a cashback scheme. For every Dollar, Pound, Yen, Euro you spend moving to OCI (Oracle Cloud Infrastructure) »
Sql2Odi, Part Two: Translate a complex SELECT statement into an ODI Mapping
Discusses translation of complex SQL SELECT statements (queries) into ODI Mappings. Shows Sql2Odi in action. »
Sql2Odi, Part One: Translate a simple SELECT statement into an ODI Mapping
Discuss Groovy scripting for Oracle Data Integrator (ODI) to generate ODI content. Discusses translation of simple SQL SELECT statements (queries) into ODI Mappings. »