There are three main types of Data warehousing architecture single-tier architecture - which aims to minimize the data volume. There should be no duplicate records in the data warehouse only single layering. It mainly focuses on generating a dense collection of data and reducing the amount of data storage, two-tier architecture- differentiates the physically accessible sources and data storage. Three-tier architecture has a top layer, reconciled layer, and the layer of the data warehouse, it contains both data warehouses and the data marts.
