topic Re: Direct Table in QlikView

Direct Table

Mon, 27 May 2013 05:58:20 GMT

In Direct Discovery feature, can we use more than one Direct table

Re: Direct Table

oleg_orlov — Mon, 27 May 2013 06:00:43 GMT

I think only one.

Re: Direct Table

Mon, 27 May 2013 06:04:51 GMT

One more favour OLEG,

I hav been through the doc for Direct Discy, and i concluded tht the working of the application will be slow if i use this feature,

i havent used it yet, bt pls let me knw abt the speed performance of this feature, and also pls throw some light on Direct Discovery which is nt covered in the document

Re: Direct Table

oleg_orlov — Mon, 27 May 2013 06:10:53 GMT

Oh, I'm sorry. Unfortunately I have never used this feature, I only heard about it.

Re: Direct Table

oleg_orlov — Mon, 27 May 2013 06:21:02 GMT

This feature lets you work with large amount of data, but speed is lower.

Re: Direct Table

malhaar — Fri, 28 Jun 2013 18:57:49 GMT

Using the DIRECT statement, you'll load ALL values for ALL dimensions and specify fields that you will use in Expressions with the 'IMPLICIT' qualifier. What this implies is a query is issued on your data source every time you make selections. Bottom-line - to obtain in-memory like performance, you'll need a blazing fast query engine like IBM Netezza or EMC Greenplum or Hadoop Hive.