The objective of this article is to understand the implementation of SCD Type2 using Python Data Processing library Pandas.
What is SCD?
Before implementing the SCD it is very important to get an understanding of SCD. SCD stands for Slowly Changing Dimension. SCD is one of the most common and integral concept of Data Warehousing (DWH) operations.
Slowly changing dimensions are the dimensions in which the data changes slowly, rather than changing regularly on a time basis.
#oracle #pandas #python3 #etl