what is the difference between aggregate table and fact
table ? how do you load these two tables ?
- 12 Answers
- 51169 Views
- Target, I also Faced
- E-Mail Answers
Answer Posted / azhar
hi,
The difference might be in the granularity level....
| Is This Answer Correct ? | 5 Yes | 4 No |
Post New Answer View All Answers
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
Explain about core dimension, balanced dimension, and dirty dimension?
What are the reasons to use a chameleon method in data warehousing?
Explain the definition of normalized and denormalized view and what are the differences between them?
How to limit the max no of rows retrieved in the report?
What are algorithms provided by Microsoft in SQL Server?
What are aggregate transformation?
What is the difference between agglomerative and divisive hierarchical clustering?
What is meant by metadata in context of a data warehouse?
what are the different views that are considered when building an object-oriented software system?
What is a junk dimension? What is the difference between junk dimension and degenerated dimension?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
Explain can report net connect multiple datasource at a time in report creation time?
Explain in detail abt measure objects? And what is the use of it? How to create it?
Ist the schema that a data warehouse system can implements.
