write a procedure for insert/replace from bse_trade to Consolidated
write a procedure for insert/replace from bse_trade to Consolidated The purpose is to eleminate duplicate entries and data cleanup while inserting the data from staging table (bse_trade) to operational table (consolidated). The in the staging table will keep on incrementing at regular interval @200 records per 10 seconds and can reach upto 7 to 10 lakh records. hence have included the prodess1 flag to check what data is already processed and which need to be process now. Rating of the procedure will be done on the performance of the procedure and how soon you can deliver it.