What is Partial Cache Mode in SSIS ?
In Partial Cache Mode, SSIS queries the database against new rows coming in from the source and if matched then that row is cached into SSIS Lookup Cache for rows coming subsequently in the data flow. When the cache becomes full, SSIS removes a few of the rows from the cache based on the usage/match statistics for those rows and loads the new matching rows into the Lookup Cache.