DW Assignment#01

This document contains questions and answers about data warehousing requirements and design. It discusses that information package diagrams are important for determining data warehouse requirements as they crystallize information needs. It also provides examples of different types of business managers and the business dimensions they are likely to consider, such as products, time, and sales regions. Finally, it states that information packages enable defining subject areas, business metrics, and other key design aspects like data access and refresh rates.

Uploaded by

Anonymous dh53q6uc

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as DOCX, PDF, TXT or read online on Scribd

0% found this document useful (0 votes)

131 views4 pages

DW Assignment#01

Uploaded by

Anonymous dh53q6uc

We take content rights seriously. If you suspect this is your content, claim it here.

Available Formats

Download as DOCX, PDF, TXT or read online on Scribd

You are on page 1/ 4

Q.

9
Requirements Definition Document Outline
1. Introduction.
2. General Requirements Descriptions.
3. Specific Requirements.
4. Information Packages.
5. Other Requirements.
User Expectations.
7. User Participation and Sign-Off.
8. General Implementation Plan.
Q. 8
Information Package Diagrams
The presence of information package diagrams in the requirements definition document is
the major and significant difference between operational systems and data warehouse systems.
Remember that information package diagrams are the best approach for determining
requirements for a data warehouse.
The information package diagrams crystallize the information requirements for the data
warehouse.
Q. 7
One-on-One interview technology is called JAD , group sessions and Questionnaires
Q. 10

Q. 6
1. Time
2. Product
3. Customer
4. Dealer
5. Payment method
Q.5
Yes, Managers think of the business in terms of business dimensions. Different kinds of questions
managers are likely to ask for decision making.

Marketing Manager
Give me sales statistics
by products, summarized by product categories, daily, weekly, and
monthly, by sale districts, by distribution channels.

The marketing manager, his business dimensions are product, product category,
time (day, week, month), sales district, and distribution channel. For the financial controller,
the business dimensions are budget line, time (month, quarter, year), district, and
division.
Q. 4
Name of major component of the formal requirements definition document (page 117)
Data source
Data transformation
Data storage
Information delivery
Information package diagram
Q.3
As the name implies, JAD is a joint process, with all the concerned groups getting
together for a well-defined purpose. It is a methodology for developing computer applications
jointly by the users and the IT professionals in a well-structured manner. JAD
centers around discussion workshops lasting a certain number of days under the direction of
a facilitator. Under suitable conditions, the JAD approach may be adapted for building a data
warehouse.
Q.2
Senior executives (including the sponsors)
Key departmental managers
Business analysts
Operational system database administrators (DBAs)
Others nominated by the above
Executives will give you a sense of direction and scope for your data warehouse. They
are the ones closely involved in the focused area. The key departmental managers are the
ones who report to the executives in the area of focus. Business analysts are the ones who
prepare reports and analyses for the executives and managers. The operational system
DBAs and IT applications staff will give you information about the data sources for the
warehouse.
Q.1
Essentially, information packages enable you to:
1. † Define the common subject areas
2. † Design key business metrics
3. † Decide how data must be presented
4. † Determine how users will aggregate or roll up
5. † Decide the data quantity for user analysis or query
6. † Decide how data will be accessed
7. † Establish data granularity
8. † Estimate data warehouse size
9. † Determine the frequency for data refreshing
10. † Ascertain how information must be packaged