Discuss the concepts associated with dimensionality modeling.
What will be an ideal response?
Every dimensional model (DM) is composed of one table with a composite primary key,
called the fact table, and a set of smaller tables, called dimension tables. Each dimension table
has a simple (noncomposite) primary key that corresponds exactly to one of the components
of the composite key in the fact table. In other words, the primary key of the fact table is made
up of two or more foreign keys. This characteristic “star-like” structure is called a star schema
or star join. Another important feature of a DM is that all natural keys are replaced with
surrogate keys. This means that every join between fact and dimension tables is based on
surrogate keys, not natural keys. Each surrogate key should have a generalized structure based
on simple integers. The use of surrogate keys allows the data in the warehouse to have some
independence from the data used and produced by the OLTP systems.
You might also like to view...
__________ sockets and the __________ protocol are more desirable for the vast majority of Java programmers.
a. Stream, UDP. b. Stream, TCP. c. Datagram, UDP. d. Datagram, TCP.
What are the problems of server-side scripts that client-side programs solve?
What will be an ideal response?
Heading 1 is an example of a(n) ________
Fill in the blank(s) with correct word
All operands used in an expression must ____ before the expression is evaluated.
A. have values assigned to them B. be simplified C. be parameterized D. be printed out