September 2001
Beginner
544 pages
17h 43m
English
Content preview from DATA WAREHOUSING FUNDAMENTALS: A Comprehensive Guide for IT Professionals
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.
6.8. EXERCISES
Match the columns:
information package diagrams
need for drill-down
data transformations
data sources
data aging
sophisticated analysis
simple and complex queries
data volume
specialized DSS
corporate data warehouse
determine data extraction
provide OLAP
provide data feed
influences load management
query management in DBMS
low levels of data
larger staging area
influence data design
possible pollution source
data staging design
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.
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.
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.
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 ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access
More than 5,000 organizations count on O’Reilly
O’Reilly covers everything we've got, with content to help us build a world-class technology community, upgrade the capabilities and competencies of our teams, and improve overall team performance as well as their engagement.Julian F.
I wanted to learn C and C++, but it didn't click for me until I picked up an O'Reilly book. When I went on the O’Reilly platform, I was astonished to find all the books there, plus live events and sandboxes so you could play around with the technology.Addison B.
I’ve been on the O’Reilly platform for more than eight years. I use a couple of learning platforms, but I'm on O'Reilly more than anybody else. When you're there, you start learning. I'm never disappointed.Amir M.
I'm always learning. So when I got on to O'Reilly, I was like a kid in a candy store. There are playlists. There are answers. There's on-demand training. It's worth its weight in gold, in terms of what it allows me to do.