what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 49562 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / ajit dada pawar
fact table is one which contains all the facts
.aggregate table is one which is created after
the cube is processed.this aggregate table contains human
unreadable text.
| Is This Answer Correct ? | 1 Yes | 10 No |
Post New Answer View All Answers
Code the tables statement for a single-level (most common) frequency?
What are the approaches used by optimizer during execution plan?
Explain clustering algorithm?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
How to know the time taken for particular report execution?
Start a batches with in a batch?
Explain the difference between dw and bi?
What is cost benefit analysis (cba)?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
Explain the definition of normalized and denormalized view?
What is critical column?
what are the all possible features supported modify stage?
What are algorithms provided by Microsoft in SQL Server?
What is Discover and Execute in XMLA?
What is the difference between aggregate table and materialized view?
