1 Reply Latest reply on Jul 22, 2020 7:45 AM by user126898

    IDQ Dynamic mapping - Data load to target table takes too much time

    Hemantkumar Patel New Member

      I've created a dynamic mapping in IDQ ,where i do merging on the target table based on the PK column. The source and target are oracle tables, the target has PK based on one column.

      As it is update operation in DB i kept the data load to normal mode.

      It takes around 1 hour to load 116K records.

      As per session log it is taking around 55 min just to write to DB.

      what could be the reason for this process not to end quickly?