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
What is the difference between static cache and dynamic cache?
what are the different views that are considered when building an object-oriented software system?
Explain what is the limit to the number of sources and targets you can have in a mapping?
Difference between PowerPlay transformer and power play reports?
In document how to create metrics?
What are the data marts?
What is the 4 + 1 view model as it relates to system modeling?
Briefly state different between data ware house & data mart?
What is data warehosuing hierarchy?
What is meant by metadata in context of a data warehouse?
What is cfapplication tag?
Suppose a null dataset with 10 variables; I want to print only name of the varibales in log window and also output window. How can we do this one?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
Explain what does level of granularity of a fact table signify?
What is data analytics in simple terms?