Staging Area

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 as the basis of mission-critical systems. […]
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 days, this is not mandatory and […]
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 perform additional aggregations or extrapolations of […]
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 have all all the data specific […]