Lookup cache option SSIS
Full Cache – For small lookup datasets
No Cache – For Volatile lookup datasets
Partial Cache – For large lookup datasets
The Full cache is optimal but it will take more memory and partial cache is little expensive than full cache mode. No cache will not use any memory and it will take longer time.