why to delete temp table ex: Resident table

[Anonymous]

why to delete temp table ex: Resident table

Thanks

[#2]

Memory. You remove everything you won't need any more.

[#3]

lets suppose there is a temp table like

Temp:

Load Id,Name from ABC.qvd;

Table1:

load * resident Temp;

drop table Temp;

we need to delete Temp Table because Table1 also has all the fields which Temp table has then it will create synthetic Table with synthetic key.

if you want to avoid extra steps to delete the resident table use preceding load.

[engishfaque]

Dear rgv,

We delete temporary tables because these tables are not more in use after resident/concatenate/incremental load. This will help us to create memory space as well.

Kind regards,

Ishfaque Ahmed

[jagan · Accepted solution]

Hi,

We need to drop the temp tables once required transformations are done, because

1. It free's the memory occupied, also the QVW file size will be reduced.

2. If you do not delete there may be chances of Circular loops or synthetic key tables.

3. We should not keep any tables or fields that are not used in front end or charts, if we keep those tables the file size will be increased and the performance of dashboard will be affected, because in runtime Qlikview puts into RAM.

Hope this helps you.

Regards,

Jagan.