CODEWITHSUNDEEP
etlssisssis-2008ssis-2005
user1254579
user1254579

Reputation: 4009

Merge join or Lookup which is cost affective in ssis

I need to join 2 tables with more than 20 million reocrds.Which of the below mentioned solution is good

    1 one Oledb componet and a lookup component

or

 2 Two oldeb componets,2 sort componets and a merge join componets

Upvotes: 0

Views: 1031

Answers (2)

raj
raj

Reputation: 1

When there are many records, the lookup option is better: it gives better performance because it is a synchronous transformation.

Upvotes: 0

Jayvee
Jayvee

Reputation: 10875

depends among other things on how many bytes from the look up table you need. If you go for merge join it probably is a good idea to read the by sql ordering by key and then connect directly to the merge join transformation.

Upvotes: 1

Related Questions