ANNOUNCEMENT: community.oracle.com is currently Read only due to planned upgrade until 29-Sep-2020 9:30 AM Pacific Time. Any changes made during Read only mode will be lost and will need to be re-entered when the application is back read/write.
I am trying to improve performance for DAC load , issue seems to be with insertion of data from W_SRVREQ_FS -> W_SRVREQ_F which are service request fact staging and main table respectively.
After analyzing why insertion is slow , We found out SQL query being fired in Informatica has joins on DATASOURCE_NUM_ID along with INTEGRATION_ID column with W_SRVREQ_D which is Service Request Dimension table .
W_SRVREQ_FS.INTEGRATION_ID = W_SRVREQ_D.INTEGRATION_ID AND