Which is best loading individual tables or Use Single Query

[Anonymous]

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

[qlikviewwizard]

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

[Anonymous]

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.