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

12.9. EXERCISES

  1. Match the columns:

    1. destructive merge

    2. full refresh

    3. character set conversion

    4. derived value

    5. immediate data extract

    6. initial load

    7. file comparison method

    8. data enrichment

    9. Type 1 dimension changes

    10. code generator

    1. use static data capture

    2. EBCDIC to ASCII

    3. technique of last resort

    4. overwrite old value

    5. new record supercedes

    6. average daily balance

    7. complete reload

    8. make data more useful

    9. create extraction program

    10. real-time data capture

  2. As the ETL expert on the data warehouse project team for a telecommunications company, write a memo to your project leader describing the types of challenges in your environment, and suggest some practical steps to meet the challenges.

  3. Your project team has decided to use the system logs for capturing the updates from the source operational systems. You have to extract data for the incremental loads from four operational systems all running on relational databases. These are four types of sales applications. You need data to update the sales data in the data warehouse. Make assumptions and describe the data extraction process.

  4. In your organization, assume that customer names and addresses are maintained in three customer files supporting three different source operational systems. Describe the possible entity identification problem you are likely to face when you consolidate the customer records from the three files. Write a procedure outlining how you propose to resolve the problem.

  5. You are the staging area expert in the data warehouse project team for a large toy manufacturer. ...

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