what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answer Posted / santosh
The difference that i know is that the aggregate tables
contain only the summaries of the data where as the fact
tables contain summaries and measures. i.e.,the grain of
the data present in fact table is more than the grain of
the data present in aggregate tables.
Is This Answer Correct ? | 15 Yes | 5 No |
Post New Answer View All Answers
Explain vldb?
What are parallel querys and query hints?
What is incremintal loading?
Difference between cold fusion mx 6 and cold fusion mx 7?
Why facts table is useful in representing the data?
Which component has onread method and what it is used for?
What are the types of partitioning?
What is a core dimension?
The same tier?
Explain dimensional modelling?
How to get the first 100 rows from the flat file into the target?
What is the limit to the number of sources and targets you can have in a mapping?
What is data warehouse architecture?
Explain hybrid slowly changing dimension?
How many types of facts and what are they?