Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 53613 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / harshad
A fact table typically has two types of columns: those that
contain numeric facts (often called measurements), and
those that are foreign keys to dimension tables. A fact
table contains either detail-level facts or facts that have
been aggregated. Fact tables that contain aggregated facts
are often called summary tables or aggregated fact. A fact
table usually contains facts with the same level of
aggregation. Though most facts are additive, they can also
be semi-additive or non-additive. Additive facts can be
aggregated by simple arithmetical addition. A common
example of this is sales. Non-additive facts cannot be
added at all. An example of this is averages. Semi-additive
facts can be aggregated along some of the dimensions and
not along others. An example of this is inventory levels,
where you cannot tell what a level means simply by looking
at it.
| Is This Answer Correct ? | 52 Yes | 3 No |
Post New Answer View All Answers
Explain about core dimension,
What are the steps involved in creating dimensional modeling process?
Describe the differences between a data warehouse and data mart.
How much data hold in one universe.
What is drilling across?
What are parallel querys and query hints?
Explain what are components of report studio?
What is the difference between view materialized view and view?
Can decision tree be implemented using SQL?
What are the advantages of raid 1, 1/0, and 5. What type of raid setup would you put your tx logs?
a perceptron has two inputs x1,x2 wih weights w1,w2and bias weight of w0. the activation function of perceptron is h(x).the output of perceptron
How to reduce warnings?
What is a hash cluster?
How do you define data block size?
What is cost benefit analysis (cba)?
