Question.1 What is the difference between Star schema and Snow flake scheme ? Answer: In Star schema, Fact table is in the center and surrounded by dimension tables. Snow flake schema is similar to star schema. In Snow flake schema, dimension tables may be connected to other related dimensions. For..
Question.1 What is a KPI? Answer: Key Performance Indicator or KPI is a key measure/s that is used by an organization to evaluate performance. KPI’s are different for different organizations, for example, for a retail company, one for the KPI may be Sales Amount, for a hospital, it may be..
Question.1 What is QlikView? Answer: QlikView is an in-memory Business Intelligence application. In-memory means data is loaded and queried from RAM. QlikView uses the associative technology. Tables having common fields are associated or linked. QlikView stores data at a granular level. Data is not pre-aggregated. Components of QlikView are QlikView..
Qustion.1 Explain Qlikview architecture? Answer: QlikView deployments have three main infrastructure components: 1.QlikView Developer : Is a Windows-based desktop tool that is used by designers and developers to create a) a data extract and transformation model and b) to create the graphical user interface (or presentation layer). 2.QlikView Server (QVS)..