what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answer Posted / ajit dada pawar
fact table is one which contains all the facts
.aggregate table is one which is created after
the cube is processed.this aggregate table contains human
unreadable text.
| Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
Explain what is a three tier data warehouse?
What is a relationship?
What is difference macros and prompts?
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
What is the difference between aggregate table and materialized view?
What are situations where snowflake schema is better than star schema when the opposite is true?
What is surrogate key? Where we use it explain with example?
How to test report in reportnet?
Explain dimensional modelling?
What are the various methods of getting incremental records or delta records from the source systems?
What is a view as it relates to system modeling?
What is Discrete and Continuous data in Data mining world?
What is difference between e-r modeling and dimensional modeling?
Explain the definition of normalized and denormalized view and what are the differences between them?
Difference between cold fusion mx 6 and cold fusion mx 7?