What are precceding load and resident load?Difference?

[#1]

Can any body explain simple way in interview point way with practical example.

Thank & Regards

Ramesh

[#2]

preceding load is like this.

load  columna, columnb, columna * 2 as columna2, columnc;

sql select columna, columb, columnc

from table1 ;

Resident load is like this.

Tablea:

select columna, value, columnb

from table1;

Tableb:

select columna, sum(value)

resident Tablea

group by columna;

[#3]

http://qlikviewnotes.blogspot.com/2009/12/simplify-with-preceeding-load.html

With Preceding it is possible to reload again and again into the same table, it is not possible to create multiple tables with Preceding reload.

Resident Load:

Temp:

LOAD

*

FROM Data;

Temp1:

LOAD

*

FROM Temp;

Temp2:

LOAD

*

FROM Temp;

But with preceding load

LOAD

*,

If(Previous(MonthYear) <> MonthYear, 1, 0) AS MonthStartFlag;   // Second preceding reload

LOAD

*,

Year(Transaction_Id) AS Year,

MonthName(Transaction_Id) AS MonthYear,

Week(Transaction_Id) AS Week;    // First preceding reload

SELECT

Transaction_Id,

Transaction_date

FROM Transaction;

If you are able to manage with preceding load, then it is better than Resident reload.

[Anonymous]

Refer this link:

Resident load and precedding load

[Siva_Sankar]

From your discussions so far, it looks like you're preparing for interview. Check out all types of loads here Different Ways to load data in qlikview

[ngulliver]

Hi, Ramesh.

Have a look at this blog on preceding loads. It may clarify things:

http://www.quickintelligence.co.uk/preceding-load-qlikview/

Cheers,

Neil