Caching Worksheets tables- how do they gets dropped ?
Hi all,
We have few Cached worksheets. Quick technical questions ?
1) Each time we refresh the Caching worksheets..we see different temp table associated. Our question is -when do the temp tables gets dropped? Is a cached temp table same as temp table?
2) There is a workflow step called- 'Drop Temp Tables'? Will this take care of the Cached tables which are no longer used?
rgds
Aqil