Category: SCD

Big Data Test – SCD – Redshift

Redshift is the first AWS technology that I am using for the big data test of slowly changing dimension processing.  The data we need has...

Big Data Test – SCD – Design

Given the requirements and the set based table recreate solution discussed in the introduction, we need more detail on the steps required to solve this...

Big Data Test – SCD – Generating Data

According to the introduction, this test needs to generate some test data.  The requirements for the test data are. The destination table will have 200...

Big Data Test – SCD – Introduction

I’ve set myself an interesting test.  What are some of the big data solutions for creating a slowly changing dimension (SCD)? Making sure everyone is up to...