The merged company described in unit 4 continues to grow. More stores have been added and internet sales are growing. The company is now considering expanding internationally. Before expansion, the company wants to explore new ways to grow, cut costs, and increase profits. In order to study the company’s sales patterns and determine their needs, the management has decided to establish a data warehouse. The merged data will be moved into the new warehouse. However, what other external feeds should be included? These can be from partners, government services, or other available rss feeds. Explain. When the data was moved into the merged database, duplicates were eliminated and errors removed. How do we ensure only clean data will be entered into the data warehouse? How frequently should the data in the data warehouse be updated? Remember the cost is inversely proportional to the time, i.e., the shorter the load interval the higher the cost. Should the update interval be the same for all feeds?

Answer rating: 100% (QA)

DATABASE WAREHOUSING AND MERGING The phrase data warehousing commonly denoted as DW is a system used for data analysis management and reporting On the same note data updating is the whole process invo... View the full answer