Preamble Thought of writing this series of posts to explain about what a data warehouse is and what are all the layers it has. Warehouse What is data warehouse and why do we need one ? We are living in a digital age and anything and everything we see and use is supported by data […]
Month: September 2021
Converting a Slowly Changing Dimension Table to A Snapshot Table using Views
In most of the data warehouses we often encounter tables populated with SCD logic to save space. It could be on the staging layer or on the Dimention or the fact tables. So if your consumption requirement demands you to have a daily snapshot (or monthly snapshot), then the first thing we do is to […]