topic Re: What are precceding load and resident load?Difference? in QlikView

What are precceding load and resident load?Difference?

Mon, 21 Jul 2014 05:22:12 GMT

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

Thank & Regards

Ramesh

Re: What are precceding load and resident load?Difference?

Mon, 21 Jul 2014 05:30:41 GMT

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;

Re: What are precceding load and resident load?Difference?

Mon, 21 Jul 2014 08:25:30 GMT

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.

Re: What are precceding load and resident load?Difference?

Anonymous — Mon, 21 Jul 2014 08:39:31 GMT

Refer this link:

Resident load and precedding load

Re: What are precceding load and resident load?Difference?

Siva_Sankar — Mon, 21 Jul 2014 08:44:14 GMT

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

Re: What are precceding load and resident load?Difference?

ngulliver — Thu, 07 Aug 2014 13:46:25 GMT

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