A Data Warehouse is a relational/multidimensional database that is designed for query and analysis rather than transaction processing. A data…