It is used to improve the performance of sql query

What are aggregate fact tables ? why they are needed? give
an example

Question Posted / omprakash

Answer Posted / omprakash

Is This Answer Correct ?

7 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the main difference between inmon and kimball philosophies of data warehousing?

1061

Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?

901

Explain how to generate iqd file from framework manager?

898

Is there any difference in testing database and data ware housing?

2693

How to define a cube??

879

Explain difference between e-r modeling and dimentional modeling?

915

What is a data profile?

907

What is the difference between star and snowflake schemas?

1111

What is the data type of the surrogate key?

927

How to calculate fact table granularity?

968

What are situations where snow flake schema is better than star schema to use and when the opposite is true?

932

Explain what is the data type of the surrogate key?

915

Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?

1160

What is a core dimension?

1011

What is Cognos script editor?

2480