What is fact constellation schema?
Answer / Jitendra Kumar Gupta
A fact constellation schema in QlikView is a data model design that combines multiple fact tables into one large table, known as the constellation fact table. This approach helps to reduce complexity by consolidating dimensions that are commonly used across multiple fact tables.nnThe benefits of using a fact constellation schema include improved query performance and reduced memory usage.
| Is This Answer Correct ? | 0 Yes | 0 No |
What type of data connections do you use?
Name some data sources used in qlikview?
If server crashes then how do you check behind it or error log where you will find that log?
What do you understand by dollar-sign expansion?
Give some date and time functions?
What are the two basic levels at which security attain in QlikView?
What is the fundamental difference between a block chart and a mekko chart?
Explain 3 tier architecture implementation while deploying qlikview application?
Describe microsoft power bi and its features?
In a comparison of the bi tools qlikview and microsoft power bi, which one of the two would you prefer and why?
What are the components working at the back end of qlikview?
What is information density in qlikview table viewer? What is subset ratio?