Being a data warehouse manager, I though I’d share the responsibilities given to a Data Warehouse Manager, with the readers of my blog. The data warehouse manager is mainly responsible for creating and maintaining the indexes on the fact and dimension data and on the aggregations. The indexes on the fact data will need to be created as soon as the data load completes. Likewise, the indexes on the aggregations will need to be created as soon as a new aggregation is built.