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

6.8. EXERCISES

  1. Match the columns:

    1. information package diagrams

    2. need for drill-down

    3. data transformations

    4. data sources

    5. data aging

    6. sophisticated analysis

    7. simple and complex queries

    8. data volume

    9. specialized DSS

    10. corporate data warehouse

    1. determine data extraction

    2. provide OLAP

    3. provide data feed

    4. influences load management

    5. query management in DBMS

    6. low levels of data

    7. larger staging area

    8. influence data design

    9. possible pollution source

    10. data staging design

  2. It is a known fact that data quality in the source systems is poor in your company. You are assigned to be the Data Quality Assurance Specialist on the project team. Deseribe what details you will include in the requirements definition document to address the data quality problem.

  3. As the analyst responsible for data loads and data refreshes, describe all the details you will look for and document during the requirements definition phase.

  4. You are the manager for the data warehouse project at a retail chain with stores all across the country and users in every store. How will you ensure that all the details necessary to decide on the DBMS are gathered during the requirements phase? Write a memo to the Senior Analyst directly responsible to coordinate the requirements definition phase.

  5. You are the Query Tools Specialist on the project team for a manufacturing company with the primary users based in the main office. These power users need sophisticated tools for analysis. How will you determine what types of information delivery methods are needed? What kinds of details ...

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