topic Which is best loading individual tables or Use Single Query in QlikView

Which is best loading individual tables or Use Single Query

Anonymous — Mon, 27 Jul 2015 15:12:16 GMT

Hi All,

I was asked the following question during interview

which of the following is best

a) Loading individual table data into qlikview (i.e load 10 different tables)

or use single sql query(i.e joining 10 tables into one dataset).

Need help on this...

With Regrads,

Manoj S Nair

Re: Which is best loading individual tables or Use Single Query

qlikviewwizard — Mon, 27 Jul 2015 15:24:43 GMT

Loading individual table's data into QVDs is very faster... and one of the best practices of Qlikview.

Re: Which is best loading individual tables or Use Single Query

Anonymous — Tue, 28 Jul 2015 04:45:43 GMT

But don't you think loading all 10 tables and data modeling it will take time. where in using single sql query will extract the required field from datasource puts into QVD's therefore no modeling is required.