Analytic Functions: Using LAG for SCD type 2

.

In one of my previous blog articles called ´´Deduplication using Analytic Function´´, I explained a simple introduction of Oracle Analytic Functions. In this article (addressed for SQL developers), I will focus on the LAG function which from my point of view, is one of the most useful functions. Let’s see the use of this function in a common Data Warehouse scenario: Slowly Changing Dimension.  Continue reading this post >

Deduplication using Analytic Function

.

When implementing an ETL, one of the most common tasks is the deduplication of rows. If you need to implement this in PL/SQL, one method could be with correlated subqueries. However, in this article we will take the approach sometimes forgotten by developers, which is using Analytic Functions.

The main objective of this article is to compare the two different ways to realize the deduplication.

Continue reading this post >

Pivot Data in Standard Query Language (SQL)

.

Pivoting data is one of the most common techniques in BI to present and manipulate data. While doing this using an ETL or BI tool is usually very simple, doing it in SQL is a more tedious task.
In this article we will see two different ways to pivot data with SQL. The first one is the classical way, while the second one uses the PIVOT clause available in Oracle 11g.
Scenario
The goal is to get the data in the following table as a data source…

Pivoting data is one of the most common techniques in BI used to present and manipulate data. Using an ETL or BI tool is usually a very simple solution; accomplishing it in SQL is more tedious.

In this article we will see two different ways to pivot data with SQL. The first one is the classical way, while the second one uses the PIVOT clause available in Oracle 11g.

Continue reading this post >

privacy policy - Copyright © 2000-2010 ClearPeaks

topnav