Limitations of Lookup Transformation

• tinku.reddy

  SSChasing Mays

  Points: 635

  More actions

  August 31, 2010 at 7:56 am

  #141778

  Hi All,

  I was asked by an interviewer about the lookup.

  1. How many max number of rows the lookup can handle. Is there any limit on that?

  2. What is disadvantage of using Partial-cache?

  Please let me know if you have any idea about this.

  This would be a great help.

  Thanks

  Tinku

• Koen Verbeeck

  SSC Guru

  Points: 259197

  More actions

  August 31, 2010 at 8:23 am

  #1214341

  http://www.sql-server-performance.com/articles/biz/SSIS_New_Features_in_SQL_Server_2008_Part1_p1.aspx

  Need an answer? No, you need a question
  My blog at https://sqlkover.com.
  MCSE Business Intelligence - Microsoft Data Platform MVP