Oracle and JSON
tom
JSON stands for Java Script Object Notation. It is a way to describe and store data. It can be read and modified in any editor. It has components that describe…
Cubes in Oracle
The issue about roll ups in Oracle is that roll up only calculate sub totals in one direction. So if you have a country, city combination, subtotals are calculated per…
Oracle: rollup totals
Oracle has a nice feature that allows to show a grand total. I assume you want to show a line with a grand total when a grouping by SQL is…
Real time loading in Oracle
The idea behind real time loading a data warehouse is to propagate data directly after an event has happened in an underlying source database. Let us think of an invoice…
Reading XML data with ODI
ODI has a feature that allows to read XML data. I really enjoyed working with this feature. It allowed to directly insert values from an XML file into different fields…
ODI and SCD
Oracle has a very nice ETL tool (or in Oracle parlance ELT tool). Its purpose is clear: make a easily maintainable set of workflows that show clearly the lineage from…
Oracle – provide a rank
Oracl has a nice feature to add a rank to a row. Let us assume you have a table with 4 values: some rows have an A, others have a…
Keeping a journal in Oracle
The idea is actually quite simple. Whenever a record in a table (here: employee) is updated with a new value in a field (here: salary), a trigger gets fired. This…
Oracle – trigger example
This note provides an example on a trigger. I like this example as it shows how additional business logic can be implemented. It is an example of a statement trigger:…
Oracle: writing to a file
Oracle has a package that allows you to write to a file. Oracle uses the concept of a directory (here “External”) that acts as a logical description of a directory.…