Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

sheronfernando
New Contributor

QVD Files

Hi Everyone,

Appreciate you support to understand below

- Does the in-memory QVW always connect to the QVD in order to 'fetch' data?

- Does a single QVD store only a single table?

- If you want the entire DB to be translated into QVDs, is that possible and what's the role of QVW in that?

Many thanks in advance

Sheron

Message was edited by: Sheron Fernando

Tags (1)
1 Solution

Accepted Solutions

Re: QVD Files

A qvw doesn't need mandatory qvd-files - loading (from any sources) and transforming the data and presenting them within gui-objects could be done within a single qvw. But quite often is a qlikview-environment splitted into multiple stages, for example: Generator --> Datamodel --> Report. Advantages of such a data-architecture are the possibility to reuse loaded/transformed data within several applications and to parallelize developing/maintaining/reload tasks which ends in more performant and stable solutions.

Yes - one qvd for one table (there are exceptions but they are not very relevant within the most scenarios).

Yes - it's possible but it will be probably only practicably if you used multiple stages with multiple qvw's as generators and datamodels like above mentioned and if the DB contained "normal" amounts of data you will probably need some incremental approaches for the bigger fact-tables to not loading all data each time else to load only new or changed data.

- Marcus

1 Reply

Re: QVD Files

A qvw doesn't need mandatory qvd-files - loading (from any sources) and transforming the data and presenting them within gui-objects could be done within a single qvw. But quite often is a qlikview-environment splitted into multiple stages, for example: Generator --> Datamodel --> Report. Advantages of such a data-architecture are the possibility to reuse loaded/transformed data within several applications and to parallelize developing/maintaining/reload tasks which ends in more performant and stable solutions.

Yes - one qvd for one table (there are exceptions but they are not very relevant within the most scenarios).

Yes - it's possible but it will be probably only practicably if you used multiple stages with multiple qvw's as generators and datamodels like above mentioned and if the DB contained "normal" amounts of data you will probably need some incremental approaches for the bigger fact-tables to not loading all data each time else to load only new or changed data.

- Marcus

Community Browser