Usually, data warehouse adapts either two-tier or three-tier architecture. We have discussed three-tire architecture in my other post 'Data Warehouse Three-tier Architecture'. In this article, we will discuss on the data warehouse two-tier architecture. Data Warehouse Two-tier Architecture  The data warehouse two-tier architecture is a client - server application. There is a direct communication between client and data source server, we call it as data layer or database layer. Usually, there is no intermediate application between client and database layer. Below diagram depicts data warehouse two-tier architecture: As shown in…

If you are working on Data warehouse project, than you might have heard lot about surrogate keys. Surrogate keys are widely accepted data warehouse design standard. In this article, we will check data warehouse surrogate key design, advantages and disadvantages. What are surrogate keys in Data warehouse? If you are a data warehouse developer, that you might be thinking what is surrogate key? How and where it is being used? You will get answers to all your questions here. Data warehouse surrogate keys are sequentially generated meaningless numbers associated with…

Building data warehouse is not different than executing other development project such as front-end application. You need to be technical and business person who understand technical details along with organizations business to successfully design and implement data warehouse project. In this article, we will check what the data warehouse project life cycle is and different steps in designing data warehouse project! Steps of Data Warehouse Project Life Cycle Design Following are steps generally followed in any data warehouse projects you can consider these steps as data warehouse lifecycle: Requirements gathering…