QlikView provides a feature called Autogenerate which use for generate data using system’s programming.
Using Autogenerate, QlikView’s software creates data automatically following a few commands. Such data which autogenerate create not load from an external source but create unique. Autogenerate might generate data like 20 random numbers, dates of 15th week of the year,...
Saturday, 19 January 2019
Can you explain Snowflaking Schema ?
Snowflake Schema: An extension of the star schema by means of applying additional dimensions to the Dimensions of a star schema in a relational environment. Snowflaking is a form of dimensional modeling; dimensions are stored in multiple relational dimension tables. A snowflake schema is a variation of the star schema. Snowflaking is used to improve the performance of specific...
What are the Identifiers Syntax?
0- Represents the empty set
1- Represents the full sets of records
$-Represents the record of current selection
$1-Represents the previous selection
$_1-Represents the next selection
Bookmark01-Represents the Bookmark name...
Saturday, 12 January 2019
What are the different types of data load in Qlikview?
There are seven different types of load in QlikView.
Load from files
Resident Load
Incremental Load
Inline Load
Add Load
Buffer Load
Binary Load...
Can you explain what will you find in the menu bar of QlikView?
On the menu bar of QlikView, there are many menus available with the help of which we can adjust the properties, make changes, add new objects in the sheet etc. The options available in the menu bar are:
File
Edit
View
Selections
Layout
Settings
Bookmarks
Reports
Tools
Object
Window
Help
...
What are the important components of QlikView’s architecture?
Dashboard
QlikView Server-QVS
QlikView Developer-QVD
QlikView Publisher-QVP
QlikView Management Console-QMC...
What are the different types of searches available in QlikView?
There are eight types of searches in QlikView:
Associative search
Advanced search
Compound search
Expression search
Fuzzy search
Normal search
Numeric search
Wildcard search
...
Subscribe to:
Posts (Atom)
- Recent
- Weekly
- Comment
Recent
Weekly
-
QlikView provides a feature called Autogenerate which...
-
Keep: it will not join two tables and they will be stored...
-
No Concatenation: if the two tables have same fields...
-
Optimized load is much faster and therefore preferable...
-
To connect a QlikView server (QVS) each client needs a...
-
Qlikview Generic Load is the load which is used in...
-
The architecture is based on site concepts. It is a...
-
1st Tier - Raw data is getting loaded and QVD is...