topic Re: QVD creation Optimized ? in QlikView

QVD creation Optimized ?

vikasmahajan — Thu, 22 Sep 2016 06:27:38 GMT

Dear All,

I am fetching data from sql with select Col1,col2,col3 from Tab ;

Question : Now for optimized qvd load can I load all data from sql with all transformations and save into QVD.

And QVD can be use as a optimized load while loading application.

Thanks

Vikas

Re: QVD creation Optimized ?

tresB — Thu, 22 Sep 2016 06:32:06 GMT

Yes you can. Where exactly do you have the doubt?

Re: QVD creation Optimized ?

vikasmahajan — Thu, 22 Sep 2016 06:46:09 GMT

Thanks tresesco ,

Suppose i have following code

Fact_Agg_Hist:

SQL SELECT

Reporting_Dt,

Event_Dt,

Load

Date(Reporting_Dt) as Reporting_Dt,

Date(Event_Dt) as Event_Dt,

If( field1=1,0,1) as New Field ;

Store Fact_Agg_Hist into Fact_Agg_Hist.qvd (qvd) ;

And when i load this qvd then this will be optimized ?

Vikas

Re: QVD creation Optimized ?

tresB — Thu, 22 Sep 2016 06:59:31 GMT

If a load is optimized or not that comes into play during your qvds load. It doesn't matter how you created them; what calculation they had. If you load the qvds directly with no transformation (actually few basic operations are considered to be permitted in optimized load. Check : https://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/) your load is optimized.

Re: QVD creation Optimized ?

vikasmahajan — Thu, 22 Sep 2016 07:05:33 GMT

Thanks Make clear

Re: QVD creation Optimized ?

Anonymous — Thu, 22 Sep 2016 07:13:11 GMT

Hi Vikas,

Yes, you are loading optimized qvd load.

Suppose, when you perform transformations and new field derivations while loading qvd file then it will be unoptimized qvd load.

Please mark question as answered if it is appropriate.