topic Re: What is optimized Qvd load in QlikView

What is optimized Qvd load

Sun, 20 Jul 2014 04:52:46 GMT

In real time work or project.

Re: What is optimized Qvd load

israrkhan — Sun, 20 Jul 2014 05:08:07 GMT

its not related to work or project,

its a way to load , Read data from qvd files into qlikview application.

if your load statement does not have where clause, than its considered as optimized load....

Re: What is optimized Qvd load

Sun, 20 Jul 2014 05:33:35 GMT

Thank you sir.Actually, it is interview point of question.my friend was asked me.

Re: What is optimized Qvd load

Anonymous — Sun, 20 Jul 2014 05:45:12 GMT

Hi,

Check below link,

http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/

Re: What is optimized Qvd load

israrkhan — Sun, 20 Jul 2014 06:00:01 GMT

search on community, as "Interview question" you will find the interview question here.

and mark as correct if you have got your answer...

Re: What is optimized Qvd load

MK_QSL — Sun, 20 Jul 2014 08:11:06 GMT

REF : Oleg Troyansky

Optimized load is much faster and therefore preferable, especially for larger data sets.

Optimized loads are possible if no transformations (calculations) are made during the load, and no (almost) filtering is done in a WHERE clause.

The only acceptable filter is using function Exists:

WHERE Exists(Field)

So for example this load can't be optimized:

Load * From ... WHERE Country = 'US'

but this load can:

Load * From ... WHERE EXISTS(Country)

================================

On the other hand, the only time you want the load not to be optimized, is if you load a Mapping table from a QVD file. In this case, Optimized load doesn't quite work, so you want to make the load non-optimized deliberately.