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.
9.2. WHY METADATA IS IMPORTANT
Let us begin with a positive assumption. Assume that your project team has successfully completed the development of the first data mart. Everything was done according to schedule. Your management is pleased that the team finished the project under budget and comfortably before the deadline. All the results proved out in comprehensive testing. Your data warehouse is ready to be deployed. This is the big day.
One of your prominent users is sitting at the workstation poised to compose and run the first query. Before he or she touches the keyboard, several important questions come to mind.
Are there any predefined queries I can look at?
What are the various elements of data in the warehouse?
Is there information about unit sales and unit costs by product?
How can I browse and see what is available?
From where did they get the data for the warehouse? From which source systems?
How did they merge the data from the telephone orders system and the mail orders system?
How old is the data in the warehouse?
When was the last time fresh data was brought in?
Are there any summaries by month and product?
These questions and several more like them are very valid and pertinent. What are the answers? Where are the answers? Can your user see the answers? How easy is it for the user to get to the answers?
Metadata in a data warehouse contains the answers to questions about the data in the data warehouse. You keep the answers in a place called the metadata repository. Even ...
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.