introduction Data Warehouse (DW or DWH) is a central repository of organizational data, which stores…