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
- 53061 Views
- Target, I also Faced
- E-Mail Answers
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 is cost benefit analysis (cba)?
What are templates in which way it is help full?
How to calculate fact table granularity?
Is there any difference in testing database and data ware housing?
Define Data Warehousing?
What are the steps involved in designing a fact table?
What are the main steps to build the data warehouse?
What are snapshots? What are materialized views & where do we use them?
Explain what are the advantages and disadvantages of reporting directly against the database?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?
Can you explain how analysis service works?
Teradata 
