Data Warehousing with Oracle

Receive updates from Data Warehousing with Oracle for free, starting right now.

We can deliver them by email, via your phone or you can read them from a personalised news page on follow.it.

This way you won't miss any new article from Data Warehousing with Oracle. Unsubscribe at any time.

Site title: Data Warehousing with Oracle | Dani Schnider's Blog

Is this your feed? Claim it!

Publisher: Unclaimed!

Message frequency: 0.1 / day

Message History

Partition by Expression2 weeks

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.

While browsing around in the

Read full story

Implementing Multi-Temporality with Data Vault (Part 3)3 weeks

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.

This blog series is a story how we implemented a data platform with Data Vault for one of my customers. The challenge was that we load data from source systems with different ...

Read full story

Implementing Multi-Temporality with Data Vault (Part 2)4 weeks

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?

Read full story