Comments by soubins (Top 1 by date)

Thanks for the reply.I reached at the conclusion that for 4K records, there is no use of storing data temporarily.
So Can you please tell me for what amount of data we need to take care about the temporary storing..
The 8 select condition are based on same column only (category).But we are loading to 8 different target table having different column names and all.