We have now gone through the process of loading data from traditional databases and simple table files. In this section, we will take a deeper look at the QVD and QVX file types, which are used by QlikView to store and read data in an optimized format. We will discuss a little more about both of these types, and the benefits and uses of each of them.
QlikView Data (QVD) files are used to extract and store data into and from QlikView. This means that whichever table you read, from whichever database, you can store it in the QVD format before or after any transformations you perform on the table. The special characteristics of this file type are:
One of the main advantages of using QVD files is that, once you have a QVD on your disk, the table can be exploited by more than one QlikView application. This reduces the load on the database server, and optimizes QlikView resources and development time. This process is called QVD staging and is discussed further in Chapter (Advanced Data Transformation), Advanced Data Transformation.
The QVD file will also be particularly useful when dealing with Incremental Load scenarios which are discussed in Chapter (Advanced Data Transformation), Advanced Data Transformation.
QlikView data eXchange (QVX) files are used for data input from external systems into QlikView. The main difference with respect to the QVD file is that QVX is a public format and can be created from external interfaces. It can be considered as the format in which custom data sources (described earlier in the chapter) send data to QlikView via the custom connector. Data retrieval becomes optimized when complying with QVX specifications, although not as optimized as QlikView's own QVD.
Qlik View Related Interview Questions
|Microstrategy Interview Questions||IBM Cognos Interview Questions|
|PL/SQL Interview Questions||MSBI Interview Questions|
|VBA For Excel Interview Questions||SAP BO Interview Questions|
|SQL Database Interview Questions||Qlik View Interview Questions|
|R Programming language Interview Questions||Pentaho Interview Questions|
|Advanced SAS Interview Questions|
Qlik View Tutorial
Seeing Is Believing
Data Modeling Best Practices
Basic Data Transformation
Set Analysis And Point In Time Reporting
Advanced Data Transformation
More On Visual Design And User Experience
All rights reserved © 2018 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.