topic resident load in QlikView

resident load

Fri, 16 May 2014 05:07:33 GMT

hieee

Can anyone make me understand what is resident load with some scenareio and is it necessay to drop previous table while using resident load

Re: resident load

arulsettu — Fri, 16 May 2014 05:21:02 GMT

we can load a field from already loaded table

Re: resident load

MayilVahanan — Fri, 16 May 2014 05:22:55 GMT

resident is used if data should be loaded from a previously loaded table.

For ex:

T1:

Load Id, field1, field2, value from tableA;

T2:

Load Id, field3 from tableB;

Join(T2)

Load Id, sum(Value) as Value resident T1;

In this example, you need to have field1, field2, value separately and also need to do some aggregation function with same field (Value). so don' t need to load the table again for do that operation.