WorkSpace in Memory option

The WorkSpace in Memory option can be a viable choice for reducing I/O usage during transformation if enough memory is available. With a smaller input data file, the transformation engine can attempt to process the work file entirely in memory.

Using this option:

  • Significantly reduces the number of I/O requests issued across the execution.
  • Produces optimal performance benefits when the work files do not exceed available physical memory. For more information about determining work file size, see the Reusing Work Files
  • When producing work files that exceed the amount of available physical memory, will cause operating system level-memory management to simulate additional memory with disk storage. This will ultimately degrade performance.