I am processing 200,000 data into a table. Inside data flow , I use look up component where the table is having 1 million records. Since i do batch process, every time the look up is taking more time due to cache memory process....How to avoid this ? Or What am i doing wrong?
Any sugesstions would be really appreciated