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
W_SRVREQ_FS.DATASOURCE_NUM_ID = W_SRVREQ_D.DATASOURCE_NUM_ID
As per my understanding DATASOURCE_NUM_ID contains the ID for source where data is coming from , for us we have single source ie Siebel and we are moving data from there to our warehouse.
So the join made on DATASOURCE_NUM_ID seems to be redundant.
I'd like to know whether removing this join will have any impact on current mapping