what is the difference between aggregate table and fact
table ? how do you load these two tables ?
Answer Posted / nethaji
fact table has measures and aggregated data .Aggregate table
has only aggregate value (ie) precalculated value.
Is This Answer Correct ? | 3 Yes | 9 No |
Post New Answer View All Answers
What is the function of etl when used in data warehousing?
What are the other names given to data warehousing?
What is your spectra photometer working principles?
What is an error log table in informatica occurs and how to maintain it in mapping?
Why should you put your data warehouse on a different system than your oltp system?
What are partition points?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What are the different problems that ?Data mining? can solve?
How to create diff. Types of templates?
How to define a cube??
Explain vldb?
Explain what are the advantages data mining over traditional approaches?
Compare aggregates and data marts
How to eliminate duplicate rows from flat file?
what are the different views that are considered when building an object-oriented software system?