What are aggregate fact tables ? why they are needed? give
an example
Answer Posted / omprakash
It is used to improve the performance of sql query
| Is This Answer Correct ? | 7 Yes | 0 No |
Post New Answer View All Answers
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
What is the difference between constraind base load ordering and target load plan?
What is is a star schema?
What are algorithms provided by Microsoft in SQL Server?
What is difference between query studio and report studio?
can anybody mail me the FAQS for hyperion essbase amd planning
Explain meta data?
What is critical column?
Explain what are the modules in power mart?
Store (and count) non-fact records?
What is the difference between junk dimension and degenerated dimension?
Suppose you are filtering the rows using a filter transformation only the rows meet the condition pass to the target. Tell me where the rows will go that does not meetthe condition.
Explain differences between star and snowflake schemas?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain er diagram?