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 18.104.22.168 on Windows 2012 R2.