Answer one of the four following questiions

The company wants to create a single data warehouse by combining several different systems. The sample files from the two systems that would supply the data for the data warehouse contain different data sets.

1. What business problems are created by not having these data in a single standard format?

2. How easy would it be to create a database with a single standard format that could store the data from both systems? Identify the problems that would have to be addressed.

3. Should the problems be solved by database specialists or general business managers? Explain.

4. Who should have the authority to finalize a single company-wide format for this information in the data warehouse?