Explain how can data generate automatically in QlikView?

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, date and days from the current date to the last of the year etc.

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 queries. The schema is diagramed with each fact surrounded by its associated dimensions as in a star schema, and those dimensions are further related to other dimensions, branching out into a snowflake pattern.

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

Can you explain the process of script execution ?

Script execution can explain through these five steps:

• Evaluation of expressions
• 
  
• Renaming of fields using the instruction as or alias
• 
  
• Qualification of fields
• 
  
• Checking for field names that match for data mapping
• 
  
• Storing the loaded data into internal tables

Can you explain start schema in Qlikview?

Star Schema:

A start schema model is a type of data model in which multiple dimensions are linked to a single fact table. Of course, in bigger models there can be multiple facts tables linked to multiple dimensions and other fact tables. The usefulness of this model lies in performing fast queries with minimal joins among various tables. The fact table contains data, which are measures and have numeric values. Calculations are applied on the fields in the fact table. The unique keys of the dimension tables are used in linking it to the fat table, which also has a key usually with the same field name. Therefore, the Fact table contains the keys from the entire dimension table and forms a concatenated primary key used in various queries.

Can you explain Boxplot and Histogram in QlikSense?

Boxplot

The boxplot becomes interesting for statistical applications. Over a dimension, it calculates the expression and finds the distribution of the values, focusing them generally into quartiles where 25% of the values, for example, fall into an area of the chart. The boxplot comes with automatic options for Standard (Tukey), Percentage, or Standard Deviation plots. The whisker length can also be configured with the default being 1.5 quartiles from either side of the box.

Histogram

The histogram is a way to group the frequency of a numeric dimension into a range. For example, how many values were between 1 and 5, and how many were between 6 and 10. It is a great way to visualize numbers that fall into a normal distribution. My data did not fall into a normal distribution.

The requirement for this chart is simply a single dimension.  It must be numeric which means that when you go to add a dimension, you will only find fields in the list that are numeric. In this case, I went ahead and created a field in the script that did the row-level math to determine the cases per 100,000 before using it in my chart. It will count up the rows into bars according to the range that you assign it in Histogram Settings. Because my range went from 0 to 45 thousand, I manually configured the Number of bars to 9.

What is Qlik sense?

Self-provider records conception utility that enables you to look and determine vast amounts of facts to find out visions of the employer. It uses analytics and Discovery of facts. With Qlik experience, an organization can create elastic, interactive visualizations and make significant decisions.

• It is fast and easy
• Redefines how you access, create and share insight
• Faster time to insight anyone, anytime, anywhere on any device.

What type of charts did you used?

Bar chart, line chart, combo chart, gauge chart, scatter chart, grid chart, pie chart, funnel chart etc.

How do you bring data into QV? Explain the script?

We can load data from ODBC, OLEDB, SAP connectors by connect, select statements and also we can load flat files like excel, word, xml etc… by using Table files syntax will be 
Directory: Load tables, from sample.txt;

What type of data connections do you use?

ODBC, OLEDB, SAP connectors

What is Set and Let?

Set: 

this command assigns the variable the text to the right of equal sign. 

Let: 

assigns the variable whereas Let command evaluates expression. 
Ex. Set Variable name = String 
     Let variable name= operation

What is cross table?

Cross table is common type of table featuring a matrix of values between two orthogonal lists of header data. To turn cross table into straight table use cross table prefix 

Ex. Cross table (attribute field name, data field name [ , n ] ) ( load statement | select statement )

What is difference between QV Server and Publisher?

QV Server: 

Qv Server is a program that is installed in a physical server (computer) with number of CAL’s these allow user to access QV files on the server. QVS controls the people who can access the documents on server using client access license (CAL). 

QV Publisher: 

QV Publisher is a program which allows you to maintain centralized control of all your QV files and to schedule when and how they reloaded and distributed. You can automatically reload files and distribute them to web access points or by email or intranet. You can do data reduction also.

Types of CALS how do you assign them?

To connect a QlikView server (QVS) each client needs a CAL (client access license) The CAL’s are purchased with QlikView Server and tied to the server serial number. A CAL is never transformed to the client but a client uses the CAL when connecting to the server. 

Cal Types: 

Named User CAL: 

Named CAL can access all the documents 

Document CAL: 

Document CAL can access particular document 

Session CAL:

A session allows any user identified or anonymous/unidentified on one QV client to access many QV documents as may reside on the server 

Usage CAL:

allows any user to access only one QV document residing on the server

Difference between RDBMS and Associative Data Model?

RDBMS: 

stands for Relational Database Management System. It organizes data into related rows and columns. It stores data in Tables having rows and columns. These tables are created and data retrieving using SQL 

Associative Database: 

The Associative Data Model is an alternative data model for database systems other data models are record based

What is Fact Constellation Schema?

Fact Constellation Schema is describes a logical database structure of Data Warehouse or Data Mart. Fact Constellation Schema can design with collection of De Normalized Fact, Shared and conformed dimensional tables. Fact Constellation Schema is an extended Decomposed Star Schema.

Difference between star schema and snow flake schema?

Star Schema: 

In a star schema, the fact table will be at center and in connected to dimensional tables. The tables are completely in De normalized Structure. SQL queries performance in good as there are less number of joins involved. Data redundancy is high and occupies more disk spaces. 

Snowflake Schema:

 is an extension of star schema where the dimension tables are further connected to one or more dimensions. The tables are partially de normalized in structure. The performance of SQL queries is little bit less compared to star schema as more no. of joins are involved. Data redundancy is low and occupies less disk space compared to star schema.

What is the use of Load statement?

The load statement loads fields from a typed ASCII file from data defined in the script from previously loaded input table, from previously loaded field. From the result of the following select statements or by generating automatically

What is the use of Select Statement?

The SQL select statement is used to identify fields and tables to load from the current database connection

What is the use of Connect statement?

The connect statement is used to establish a connection to the database through an ODBC or OLEDB interface.