Thank you for sharing your thoughts.

I will try both the options to merge and to use stage table.

Let me first try stage table and then switch off the data to paritioned table. Let me check the performance and report back to you all.