topic Resident load in QlikView

Resident load

Tue, 28 Jan 2014 11:39:43 GMT

Hi fnds,

I have a question in my mind that after every resident load do we need to drop that table from where we have extracted.

Sales_T:

Load * Inline [

TxnID,Amount

101,456454

102,456454

103,455446

104,456787

105,446464

106,458464

];

Sales:

Load * resident Sales_T;

Drop Table Sales_T;

In which case we should go for dropping the table.

Re: Resident load

vipin_mishra479 — Tue, 28 Jan 2014 11:45:39 GMT

for in this case

if u not use drop table automatically data are double because its automatically concat the both table.

there is two way to work on this

1 use no concatenation

2 drop table

Re: Resident load

nilesh_gangurde — Tue, 28 Jan 2014 11:48:00 GMT

Hi,

Whenever you will take the resident load then you have the same data in two tables.

these two tables will consume RAM.

hence to avoid the RAM consumption we need to drop the table.

-Nilesh

Re: Resident load

Tue, 28 Jan 2014 12:16:55 GMT

Thank you Nilesh and Vipin

Re: Resident load

NareshGuntur — Tue, 28 Jan 2014 12:35:46 GMT

Hi Deepthi,

In the above case, if you run the script, you will not get any data. It happens like this.

1. First table will be loaded.

2. The resident load table(2nd table) will get automatically concatenated to the first table as all the fields are same.

3. Now when you drop the first table, there will no tables in your data model.

So, now even you drop the table, the purpose is not getting served. Before using resident load, it is always advisable to use noconcatenate if all the fields are same.

The main reason behind dropping the original table is whatever data is required is already there in the second table.

Cheers,

Naresh

Re: Resident load

Anonymous — Tue, 28 Jan 2014 12:47:03 GMT

Apart from avoiding Ram consumption and concatenating of tables

Its Best practice to clean-up as you go, which avoids loading fields not used in visualization.

So list of field to select will be short and user friendly.

Re: Resident load

Tue, 28 Jan 2014 15:56:02 GMT

Yes Naresh.I got that now.But i took only two tables but in the middile i have same table columns of Sales_T with different data.There i need to do concatenation.but i took that two tables to show an example.But the example was wrong.I got the depth concept by ur reply.

Thank you & Regards,

Deepthi

Re: Resident load

alis2063 — Sun, 13 Aug 2017 08:55:37 GMT

Dear Vipin ,

i have checked the same that it does not twice even i did not drop the Main Table/(Drop Table Sales_T).

Please be sure if you are assisting someone about fundamental

Re: Resident load

NareshGuntur — Mon, 14 Aug 2017 05:05:40 GMT

Interesting....

Hi Ali

Can you post the QVW that you have used for this.

Re: Resident load

Kohli — Tue, 06 Feb 2018 06:33:05 GMT

Sales_T:

Load * Inline [

TxnID,Amount

101,456454

102,456454

103,455446

104,456787

105,446464

106,458464

];

Sales:

Load * resident Sales_T;

Drop Table Sales_T;

In above case we can't remove the Sale_T table. We have to remove the Sales(Parant) table. The Sales_T data will get from Sales table.