May 8, 2008 at 7:22 am
hello,
m developing one package in SSIS. in that m i have to join multiple tables.
my flow is like,
OLEDB SRC-->MULTICAST TRASNS
|100
---------------------------------
100 | 100| 100| 100 |
LOOKUP1 LOOKUP2 LOOKUP3 LOOKUP4
| | | | | | | |
UNION ALL UNION ALL UNION ALL UNION ALL | | | | |
---------------------------------
|400
UNION ALL
Here m using union all after lookup to coz i want both the o/p of look up .
My problem is when m using Union All then m getting 400
records in target but i want only 100
means i want the join
but if i use Merge join it need the sorted inputs so i hv to add sort & due to merge join performance will degrade .
can anybody will gv me any alternative parallel design. without using merge join.
please help me
May 8, 2008 at 7:46 am
Check out this post, they have some suggestions http://www.sqlservercentral.com/Forums/Topic486271-148-1.aspx
May 8, 2008 at 11:57 am
My question would be why do you use Union All 4 times after each lookup? Why don't you just use 1 Union All and try it.
[font="Verdana"]Imagination is more important than knowledge-Albert Einstein[/font]
May 9, 2008 at 3:42 am
hi thnx 4 the reply
i was using union all coz i wann the look up result as left outer join.
i got the very good solution 4 this if i configure the error out put of LOOK UP to IGNORE FAILURE thn LOOKUP act as Left outer join.
now m not using multiple union all.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply