QVD creation Optimized ?

[vikasmahajan]

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

[tresesco]

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

[vikasmahajan]

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

[tresesco · Accepted solution]

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.

[vikasmahajan]

Thanks Make clear

[Anonymous]

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.