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
- 53162 Views
- Target, I also Faced
- E-Mail Answers
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 about core dimension, balanced dimension, and dirty dimension?
What is data type of the surrogate key?
explain about balanced dimension,
What is data mart in data warehouse?
What are the different types of join operations?
What are components of report studio?
Explain what are slowly changing dimensions?
Explain if a flat file cotains 1000 records how can I get first and last records only?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
Explain what is the metadata extension?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
What is conformed fact?
Where the cache files stored?
Explain dimensional modelling?
