what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 51160 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 are session timeout and application timeout?
What are the various methods of getting incremental records or delta records from the source systems?
Explain how are the dimension tables designed?
What is aggregate fact table?
What is difference between e-r modeling and dimensional modeling?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
How can we acheive correlated sub-query in designer?can anyone help me in this regard?
What are the various transformation available?
How can we load the time dimension?
What is dimension modeling?
What is MDX?
Teradata 
