SSIS Cache transformation.Is it a good or beneficial to use this If the package consists of one and only one dimension Lookup
===

.Is it a good or beneficial to use cache transformation If the package consists of one and only one dimension Look up.I have been asked to cache all the dimensions which are being looked up in the future part of the SSIS packages.one of the dimensions , The Customer Dimension is being looked up(look up component) only one time in the package.So in this situation do i need to **cache** the Customer dimension at the beginning of the package?Will that Improve the **performance**.Or instead of doing that why can not I go ahead directly with out using cache(since there is only one look up on that particular dimension).I think I can do the cache when there are more that one look up on that particular dimension.Is my thinking correct??