Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Help me some one This Query
How could you say QVD is Optimized ? some one as asked this Question
Thanks in Advance
Niranjan
Hi Niranjan,
When we load data from any source into Qlikview, the data are compressed in a way of array pointer concept.
Ex:- In a table we have 2 fields and 10 rows.
| F1 | F2 |
| A1 | 10 |
| B1 | 20 |
| A2 | 30 |
| B2 | 40 |
| A1 | 50 |
| A2 | 60 |
| B1 | 70 |
| A1 | 80 |
While loading into Qlikview it consider the above data as given below.
Considering the value A1 once and identifying the occurence of the value in the form of pointer. Physically A1 is appearing once and the count of occurence is 3. By doing this the amount of space is less and hence the data are compressed.
Hope this helps!
--
Vinoth
Hi, Niru Niru.
Have a look at this article on Optimisation. It may help you.
http://www.quickintelligence.co.uk/qlikview-optimised-qvd-loads/
Regards,
Neil