0 Replies Latest reply on May 4, 2017 12:03 PM by user2461087

    Do we need to make join on DATASOURCE_NUM_ID while moving data from Siebel to Warehouse

    user2461087

      Hi ,

       

      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

       

      Regards,

      S