Questions from Database Management

Q: Which three techniques form the building blocks of any data integration approach

Which three techniques form the building blocks of any data integration approach?

Q: Explain why it is essential to scrub data before transformation and how

Explain why it is essential to scrub data before transformation and how they blend together.

Q: List six typical characteristics of reconciled data.

List six typical characteristics of reconciled data.

Q: Contrast the following terms: a. transient data; periodic

Contrast the following terms: a. transient data; periodic data b. data scrubbing; data transformation c. data warehouse; data mart; operational data store d. reconciled data; derived data e. static ex...

Q: List and briefly describe five steps in the data reconciliation process.

List and briefly describe five steps in the data reconciliation process.

Q: List five errors and inconsistencies that are commonly found in operational data

List five errors and inconsistencies that are commonly found in operational data.

Q: Explain how the phrase “extract–transform–load” relates

Explain how the phrase “extract–transform–load” relates to the data reconciliation process.

Q: Explain the reasons why Data Warehousing 2.0 is necessary.

Explain the reasons why Data Warehousing 2.0 is necessary.

Q: Martin was very impressed with your project plan and has given you

Martin was very impressed with your project plan and has given you the go-ahead for the project. He also indicates to you that he has e-mails from several key staff members that should help with the d...

Q: List the functions performed by a Data Warehouse Administrator and explain how

List the functions performed by a Data Warehouse Administrator and explain how they differ from the typical data administrator and database administrator.