what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answers were Sorted based on User's Feedback
Answer / jayalakshmi
fact table is one which contains all the facts
(measures).aggregate table is one which is created after
the cube is processed.this aggregate table contains human
unreadable text.
| Is This Answer Correct ? | 14 Yes | 50 No |
What are cluster analysis in data warehousing?
Can you brief about the Data warehouse project you worked on?
Explain why fact table is in normal form?
Suggest a good author for hyperion in data warehousing?
How to import vsam files from source to target. Do we need a special plugin?
Explain what are the different types of data warehousing?
What are the different problems that ?Data mining? can solve?
Explain in detail abt measure objects? And what is the use of it? How to create it?
How to design file watch jobs?
Explain what is the advantages data mining over traditional approaches?
how do you use commit frequencies? how does it affect loading performance?
What is Cognos script editor?