Data warehousing is a significant division of an association as it assists in the silky operations of the dissimilar departments. It is a must have in each minute and large organization. The architecture of a data warehouse defines its achievement. The article here talks about data warehouse architecture, its construction and performance.