January 7, 2017
Repository Database

Use of an ODS in conjunction with a DWH

ODS plays a dual role, it is operational, providing high response time and availability and is certainly qualified to act […]
January 7, 2017
ODS vs Staging

Staging vs ODS

ODS can be considered as a staging area as the data can be stored here temporarily (about 45 to 60 […]
December 24, 2016
Data Replication

We know that Data Warehouse is loaded from staging tables, then same data will be present at both the places for same time period, unnecessarily creating duplicate dataset. Can’t we have any other method to avoid this?

Its not always mandatory or true to have the same data in staging and in the Data Warehouse. You can […]
December 24, 2016
multiple data stages

Instead of having multiple staging tables, can I stick with only one and do all my validations in the memory and insert the data to the star schema?

Yes, you can. End of it, these are relational and would work as we code and design them. We can […]