How to address the issue of Incremental load when for an update or an insert it has to look up against 12 different fields and performance should not go down
We need more information than what you have provided. What are the steps in your current process? What do you mean when you say "Performance can't go down"? Any additional steps added WILL add some time to the process. Have you read the article, Anatomy of an Incremental Load[/url], by SSIS expert Andy Leonard?