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.