Data warehouse architecture A typical data warehouse architecture has different layers of Source, Staging, Data warehouse database and Business intelligence. Various activities happen in each layer.