Skip to primary content
Skip to secondary content

Data Warehousing with Oracle

Dani Schnider's Blog

Data Warehousing with Oracle

Main menu

  • Home
  • Contact
  • About
  • Publications
  • Presentations

Post navigation

← Older posts

How to Find and Avoid Duplicates in Data Integration #JoelKallmanDay

Posted on 14. October 2026 by Dani Schnider
1

Duplicate rows are the enemy of every data integration developer. They can cause job failures and – even worse – wrong results. Somtimes it is more complex than expected to avoid them. In this blog post, let’s compare different approaches.

Continue reading →

Posted in ETL, Oracle 26ai, SQL | 1 Reply

Aggregation Filters in Oracle 26ai

Posted on 20. September 2026 by Dani Schnider
Reply

The FILTER clause in SQL allows an easy way of adding WHERE conditions to aggregation functions. There were other ways to implement this before, but this syntax extension is easier to understand. In Oracle databases, it is available since version 23.26.1.

Continue reading →

Posted in Oracle 26ai, SQL | Leave a reply

JOIN TO ONE and Star Schemas

Posted on 18. July 2026 by Dani Schnider
Reply

Oracle’s new JOIN TO ONE syntax offers several benefits for queries in star schemas. Let’s take a look at some typical use cases involving facts and dimensions, and see how the new join option can help reduce complexity and avoid incorrect results.

Continue reading →

Posted in Dimensional Modeling, Oracle 26ai, SQL | Leave a reply

JOIN TO ONE and Constraints

Posted on 30. June 2026 by Dani Schnider
Reply

The new JOIN TO ONE syntax extension seems to be very useful for queries on star schemas. But before we can use it, we have to prove how they can be combined with different types of constraint definitions.

Continue reading →

Posted in Oracle 26ai, Performance, SQL | Leave a reply

Partition by Expression

Posted on 22. May 2026 by Dani Schnider
Reply

In the latest version of the Oracle database, it is now possible to define the partition key of a partitioned table using an expression. This was already possible previously, but only with a small workaround.

Continue reading →

Posted in Oracle 26ai, Partitioning, SQL | Leave a reply

Implementing Multi-Temporality with Data Vault (Part 3)

Posted on 16. May 2026 by Dani Schnider
Reply

In the last part of this blog series, we will look at how to load Slowly Changing Dimension (type SCD1 and SCD2) from the Current Views we created in our multi-temporal Data Vault schema.

Continue reading →

Posted in Data Vault Modeling, DWH Architecture, ETL, Performance, SQL | Leave a reply

Implementing Multi-Temporality with Data Vault (Part 2)

Posted on 8. May 2026 by Dani Schnider
Reply

Loading multi-temporal data into Data Vault is quite simple, a explained in the previous blog post of this series. But how can we extract the current data in a simple and convenient way to populate Data Marts?

Continue reading →

Posted in Data Vault Modeling, DWH Architecture, ETL, SQL | Leave a reply

Implementing Multi-Temporality with Data Vault (Part 1)

Posted on 5. May 2026 by Dani Schnider
10

Data change tracking is a key concept in any data warehouse and many other analytical systems. Rather than explaining the same concepts over and over again, I decided to write a blog series on this topic. This might also be of interest to others – perhaps even to you.

Continue reading →

Posted in Data Vault Modeling, DWH Architecture, ETL | 10 Replies

Playing around with Calendar Functions in Oracle 26ai

Posted on 12. April 2026 by Dani Schnider
Reply

Date calculations are sometimes a bit tricky. A set of new calendar functions in Oracle 26ai helps to simplify data arithmetic in SQL.

Continue reading →

Posted in Oracle 26ai, SQL | Leave a reply

QUALIFY: The WHERE Condition for Analytic Functions

Posted on 24. October 2025 by Dani Schnider
Reply

Filtering analytic functions was not straight-forward in Oracle and most other databases. Oracle 26ai now supports the QUALIFY clause in SQL. It works like a WHERE condition, but can be used for analytic functions.

Continue reading →
Posted in Oracle 23ai, Oracle 26ai, SQL | Leave a reply

Post navigation

← Older posts

Categories

  • ADWC (6)
  • Books (9)
  • Cloud (6)
  • Conferences (21)
  • Data Vault Modeling (24)
  • Dimensional Modeling (16)
  • DWH Architecture (21)
  • DWH Automation (5)
  • ETL (32)
  • In-Memory (6)
  • Materialized Views (6)
  • Oracle (89)
  • Oracle 12c (27)
  • Oracle 19c (3)
  • Oracle 20c (1)
  • Oracle 23ai (4)
  • Oracle 23c (5)
  • Oracle 26ai (7)
  • Oracle Data Integrator (1)
  • Oracle OpenWorld (8)
  • Oracle Warehouse Builder (7)
  • Partitioning (22)
  • Performance (54)
  • PL/SQL (9)
  • Relational Modeling (3)
  • Snowflake (1)
  • SQL (58)

Archives

  • October 2026
  • September 2026
  • July 2026
  • June 2026
  • May 2026
  • April 2026
  • October 2025
  • August 2025
  • July 2024
  • June 2024
  • November 2023
  • July 2023
  • May 2023
  • April 2023
  • January 2023
  • December 2022
  • November 2022
  • October 2022
  • August 2022
  • July 2022
  • June 2022
  • May 2022
  • February 2022
  • December 2021
  • January 2021
  • December 2020
  • November 2020
  • June 2020
  • April 2020
  • February 2020
  • December 2019
  • October 2019
  • July 2019
  • June 2019
  • April 2019
  • March 2019
  • February 2019
  • December 2018
  • September 2018
  • July 2018
  • June 2018
  • May 2018
  • April 2018
  • February 2018
  • January 2018
  • December 2017
  • November 2017
  • October 2017
  • September 2017
  • July 2017
  • June 2017
  • May 2017
  • April 2017
  • February 2017
  • January 2017
  • December 2016
  • November 2016
  • October 2016
  • September 2016
  • July 2016
  • June 2016
  • April 2016
  • February 2016
  • January 2016
  • December 2015
  • November 2015
  • September 2015
  • August 2015
  • July 2015
  • June 2015
  • April 2015
  • March 2015
  • January 2015
  • December 2014
  • October 2014
  • August 2014
  • July 2014
  • June 2014
  • October 2013
  • July 2013
  • June 2013
  • April 2013
  • March 2013
  • June 2012
  • May 2012
  • January 2012
  • October 2011
  • September 2011
  • August 2011
  • July 2011
  • June 2011
  • April 2011
Blog at WordPress.com.
Data Warehousing with Oracle
Blog at WordPress.com.
  • Subscribe Subscribed
    Data Warehousing with Oracle
    Join 138 other subscribers

    Have a WordPress.com account? Log in now.

  • Data Warehousing with Oracle
    View site in Reader
    Manage subscriptionsSign upLog in
    Report this content
    Collapse this bar
Loading Comments...