Resident load

[#1]

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.

[vipin_mishra479]

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

[nilesh_gangurde]

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

[#4]

Thank you Nilesh and Vipin

[NareshGuntur]

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

[Anonymous]

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.

[#7]

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

[alis2063]

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

[NareshGuntur]

Interesting....

Hi Ali

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

[Kohli]

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.