O'Reilly logo

DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals by Paulraj Ponniah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

2.8. EXERCISES

  1. Match the columns:

    1. a.nonvolatile data

    2. dual data granularity

    3. dependent data mart

    4. disparate data

    5. decision support

    6. data staging

    7. data mining

    8. metadata

    9. operational systems

    10. internal data

    1. roadmap for users

    2. subject-oriented

    3. knowledge discovery

    4. private spreadsheets

    5. application flavor

    6. because of multiple sources

    7. details and summary

    8. read-only

    9. workbench for data integration

    10. data from main data warehouse

  2. A data warehouse is subject-oriented. What would be the major critical business subjects for the following companies?

    1. an international manufacturing company

    2. a local community bank

    3. a domestic hotel chain

  3. You are the data analyst on the project team building a data warehouse for an insurance company. List the possible data sources from which you will bring the data into your data warehouse. State your assumptions.

  4. For an airlines company, identify three operational applications that would feed into the data warehouse. What would be the data load and refresh cycles?

  5. Prepare a table showing all the potential users and information delivery methods for a data warehouse supporting a large national grocery chain.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required