Hi abhiram0616,
Please read this:
One of the things that new developers often ask about QVDs is, "why?". They wonder
why they need to use QVDs. They know that they can connect to a database and read
data and they feel that they can do that again and again and don't see any reason why
they need to bother writing the data to a QVD file first. There are, however, several
very good reasons to store data in QVDs:
• Speeding up loads by storing data that doesn't change, or doesn't change
very frequently. Loading data from a database is relatively much slower
than loading data from a local QVD. For example, if you have 2-year-old
transactions, that won't change; you could have those in QVDs, and then
load newer transactions from the database and concatenate the two sets of
data. Of course, this also reduces the load on the database server because
we are only looking for relatively few rows of data on each SQL call.
• Combining data from multiple different sources. For example, we could have
a new ERP system in place but we also want to add in sales information from
an old system. If we keep the old data in QVD, we don't need to have the old
database online, so it can be decommissioned.
• Incremental load is the ultimate use of QVDs to load transactional information
in the minimum amount of time possible. Basically, we load only the newest
data from the database, combine with the older data from locally stored QVDs,
and then update the QVDs.
•QlikView Data Modeling, dimensional modeling
approaches say that we should use conformed dimensions where dimensions
are shared across different models. This is an excellent use of QVDs—we
create the QVD once and then can share it across many QlikView documents.
Even if we are not following a strict dimensional modeling approach, we can
still use QVDs to reuse data in more than one application.
• Implementing data quality when preparing data for users. A cleaned set of
QVD files, that are centrally created and controlled, can be provisioned for
users with confidence that data is correct.
Just from a development point of view, you will find that you are performing reloads
again and again as you are perfecting your data model. If you are reloading from a
slow database connection, this can be painful. If you create local QVDs, then your
development efforts will proceed a lot faster.
Courtesy - Mastering Qlikview Book
.png "Former Employee"){kind=icon}