Hi All,
I have a requirement to populate a custom table from oracle HRMS standard table with a list of 50 different columns like Person name, Number, basic salary, PF contribution etc.
All are derived columns.
I am using Eligibility criteria to select list of employees eligible for Pension and then populating thier complete details into the Custom table. In my pervious post Gaff had suggested to use Merge for Incremental update.
Actually i have completed the Task. It is performing incremental updated. I tested with 100 records and it worked in seconds. Now when I go for 1500 records, the performance is not as expected. Could any one suggest me any workaroud to tackle this.
1. Get list of eligible employees into a Global temp table(takes only peson Id )
2. Execute the master view with where clause person_id in (select person_id from Global_temp_personId_tab)
3. Fetch the Cursor in BULK and insert it into another Global temp Table( takes all employee details )
4. Use merge on Destination table with source as Global Details Temp table.
For 100 records it takes 7 secs .
I have a requirement to process 5000 records. Please let me know any suggestions.... I am on a tight schedule. to complete this.
Please help on this.!