12 Store Dimension SCD1 Load

Video explains - How to design SCD1 Dimension ? It also explains the basic strategy used to Load different layers of data for Store dimension. Also understand how to setup SCD1 ? Understand how to archive files in AWS S3 using Boto3.

We are going to use AWS Cloud services to design the Data Lakehouse and Processing power of Spark to load & process the data.

Chapters:
00:00 - Introduction
01:30 - Store Dimension Landing Load
02:04 - Store Dimension Staging Load
02:20 - Store Dimension SCD1 Load
03:32 - Store Dimension Load

Resources:
Ease With Data Github URL - https://github.com/subhamkharwal/ease-with-data
DW with PySpark Github URL - https://github.com/subhamkharwal/ease-with-data/tree/master/dw-with-pyspark
Docker Github URL - https://github.com/subhamkharwal/docker-images

If you are new to Data Warehousing checkout our playlist on YouTube - https://www.youtube.com/watch?v=HrFMKGGb1gM&list=PL2IsFZBGM_IE-EvpN9gaZZukj-ysFudag

New Video will be uploaded every 3 days. Stay Tuned. Make sure to Like and Subscribe.

#datalakehouse #pyspark #deltalake #datawarehousing #dw #datawarehouse

Видео 12 Store Dimension SCD1 Load канала Ease With Data