0 Replies Latest reply on Dec 19, 2019 3:06 PM by Sonja S

    Mapping taking a long time to execute

    Sonja S

      Hi

      we have this mapping which is copying all data from one table to another. The source table has about 24 million of records and the target table is truncated prior to the load. The mapping takes almost 2 hours to execute and we are looking into ways to speed this up. We can not filter the data or use an index, as we are literally copying all records from the source table.

       

      Anyone has some nice ideas of how can we speed the lazy mapping ? :-)

      Perhaps we need to play with execution (run time or so) parameters?

       

      btw. OWB is 11.2 and DB is 11.2.0.4 on Windows 2012 R2.

       

      thanks

      Sonja