What do you understand by fact constellation schema?
Answer / Mohd Zoraiz
Fact Constellation Schema is a data modeling approach used in QlikView to optimize performance and facilitate complex data analysis. It involves creating multiple fact tables (facts) that represent various aspects of the business, each containing measures (numbers), and linking them with dimension tables using associative relationships.nnThis schema allows users to easily navigate through different facts while maintaining quick response times. Each fact can be analyzed independently or in combination with others, making it an effective approach for handling large and complex datasets.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is aggr function?
What is a pivot table in qlikview?
What are kml and xml files?
Explain 3 tier architecture implementation while deploying qlikview application?
What is synthetic key?
How can we get the number of statements which have caused errors during a script execution?
What do you understand by dollar-sign expansion?
Explain Gauge charts?
Tell three major disadvantages of using qlikview?
How can you reload a script?
What do you understand by QlikView Distribution Service?
What do you understand by Kurtosis() and Skew() functions?