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
- 53542 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 |
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What is Bulk Insert?
Why facts table is useful in representing the data?
Explain what is fact less fact table? Where you have used it in your project?
Tell me one example for junk dimension?
Explain the different types of data warehousing?
What is Cognos script editor?
what is parallel query?
How would you write a simple stored procedure in tsql which takes a movie_id and returns all the directors associated with it?
What are components of report studio?
How can we run the graph?
Explain what are the mapping paramaters and maping variables?
Teradata 
