A construction supply company wants to implement a data warehouse to analyze the performance of their online portal for ordering custom cuts of lumber.
Their sales data is currently stored in two separate transaction processing relational databases, one contains inventory and the other one contains sales data. Both databases save their data in a normalized schema. One of the reasons for implementing a data warehouse is that querying the databases for average sales data and inventory status through time is slow and causes some online transactions to timeout.
How should the data warehouse be implemented?
(Select all acceptable answers.)