CleanerVersion adds a versioning/historizing layer to your relational DB which implements a "Slowly Changing Dimensions Type 2" behavior
-
Updated
Feb 7, 2019 - Python
#
slowly-changing-dimensions
Here are 20 public repositories matching this topic...
Slowly Changing Dimension type 2 using Hive query language using exclusive join technique with ORC Hive tables, partitioned and clustered hive table performance comparison
-
Updated
May 11, 2019 - Python
Spark implementation of Slowly Changing Dimension type 2
-
Updated
Jan 8, 2019 - Scala
ETL process using Pentaho Data Integration (Kettle), for Sales and Purchases Datamarts from Adventureworks, as the final project from the Data Management course from the Big Data & Analytics Masters @ EAE class of 2021
-
Updated
Jun 16, 2021 - TSQL
Applying data engineering techniques to create data pipeline with Azure Cloud Computing
api-client data-engineering selenium-webdriver azure-storage slowly-changing-dimensions azure-databricks
-
Updated
Jul 4, 2022 - Python
Dive deep into Slowly Changing Dimensions (SCD) ETL in action with this comprehensive tutorial! In this video, we'll explore how to effectively manage changing data using SQL Server Management Studio (SSMS) and SQL Server Integration Services (SSIS).
-
Updated
Apr 15, 2024 - TSQL
An ETL Data Pipelines Project that uses AirFlow DAGs to extract accessories and jewelry data from PostgreSQL Schemas and the shoes data from a CSV file, load them in AWS Data Lake, transform them with Python script, and finally load them into SnowFlake Data warehouse using SCD type 2.
python aws postgres airflow etl s3-bucket pandas data-warehouse slowly-changing-dimensions snowfalek
-
Updated
Nov 25, 2023 - Python
This repository contains materials from all disciplines of the fourth semester
roadmap microservice fault-tolerance mvp assembler data-wrangling pitch product-backlog slowly-changing-dimensions mindmap model-evaluation event-driven-architecture userstories model-refinement clastering
-
Updated
Aug 18, 2024 - Jupyter Notebook
Designing a pipeline in SSIS
-
Updated
Jul 5, 2024 - TSQL
This project documentation was developed as a free project, as a data analyst from the fictional company Sell Boardgames would do in his daily work.
python sql sql-server etl backup-script data-analysis dax powerbi datawarehouse stored-procedures powerpoint-presentations slowly-changing-dimensions reporting-services staging-area integration-services star-schema analysis-services data-vizualization abc-analysis common-table-expressions
-
Updated
Aug 29, 2023 - TSQL
This project involves helping a company's HR department analyze the effectiveness of its employee gender diversity program.
-
Updated
Aug 23, 2022
Projeto de dbt em um sistema de vendas, nesse caso mostra somente as vendas que foram concluidas, aplicando o SCD na camada Marts
python pipeline postgresql elt slowly-changing-dimensions snapshots duckdb dbt-tests dbt-macros dbt-postgres
-
Updated
Jan 10, 2025 - Python
Exploring Data Engineering concepts
-
Updated
Nov 20, 2024 - Shell
The mercor-ai Slowly Changing Dimensions (SCD) assignment repository
-
Updated
Apr 22, 2025 - Java
End-to-end sales data warehouse built with Databricks Delta Live Tables. Features automated ETL, change data capture, and medallion architecture. Transforms raw multi-region sales data into analytics-ready dimensional models.
python sql etl pyspark data-engineering business-intelligence databricks change-data-capture slowly-changing-dimensions declarative-pipeline delta-live-tables medallion-architecture
-
Updated
Sep 10, 2025 - Python
-
Updated
Jul 18, 2025
Example of how to use Snapshots in DBT
-
Updated
Sep 1, 2024
Solution of DW assignment with SSIS. Question2: type-2 slowly changing dimension with incremental loading. Quesiton3: Versioning
-
Updated
May 21, 2025
An simple example of SCD Type 2 using single 'inserted' column.
-
Updated
Feb 21, 2024 - Java
Improve this page
Add a description, image, and links to the slowly-changing-dimensions topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the slowly-changing-dimensions topic, visit your repo's landing page and select "manage topics."