Applymap - Clear from memory

[juleshartley]

Hi,

I just wondered if anyone knew of a way to clear out any mapping loads from memory mid way through a load script?

Perhaps load again with same table name but no rows?

We have a very memory-intensive load and it might help to streamline it.

Thanks

[rwunderlich]

I don't think it's possible.  My experience is that once you create a Mapping table, you cannot modify it.  For example, concatenate will not add rows. 

-Rob

[dwforest]

You could load it as a normal table and JOIN the results instead and drop when done