WarmCaches property in Fuzzy loop in SSIS

WarmCaches are very important for speed with large datasets but do take more memory. By default value of this property is true.

  

We can specify whether the transformation partially caches the index and reference table in memory before the transformation does its work. If we set the WarmCaches property to True, the index and reference table are loaded into memory. When the input has many rows, setting the WarmCaches property to True can improve the performance of the transformation. When the number of input rows is small, setting the WarmCaches property to False can make the reuse of a large index faster.