SSIS Dataflow merge join and sort tranfomation (fully block performance)

Hi,
Currently working with Dataflow task in ssis having an issue with merge join.

merge join always require sorted property o set true.

then if we want to use multiple merge join then we have use sort tranformation which is fully block so which reduces the performance.

Is there any way to overcome these problem.

Thank in Advance.
LVL 14
nishant joshiTechnology Development ConsultantAsked:
Who is Participating?
 
nishant joshiConnect With a Mentor Technology Development ConsultantAuthor Commented:
Thanks for comment.
I want use multiple joins

like

select * from test t
join xys on xyz. =
join xyz1 on xyz1. = 

Open in new window


i know look up with is fast for less data not for big data.
0
 
SThayaTechnical MAnagerCommented:
Hi,

  For sorting incomming rows ,instead Sort Transformation .you can set the sort operation in OLD DB source .
check the below link

http://www.ssistalk.com/2009/09/17/ssis-avoiding-the-sort-components/

if suppose you are doing any join opeartion use Look up ... this is fast in performance wise .

by using the above you can redirect your matching and nonmatching rows like merge join .

if you want more information , pleaae let me know your Scenario.

Thaya.S
0
 
nishant joshiTechnology Development ConsultantAuthor Commented:
Not get solution
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.