SSIS数据流任务在合并联接后删除完全块排序 [英] SSIS dataflow task remove fully block sort after merge join

问题描述

当前在sis中使用Dataflow任务时遇到合并联接问题.

合并连接始终需要排序的属性或将其设置为true.

然后，如果我们要使用多个合并联接，则可以使用完全阻塞的排序转换，这样会降低性能.

有什么办法可以克服这些问题.

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.

推荐答案

合并联接"转换提供通过使用FULL，LEFT或INNER联接将两个排序的数据集联接而生成的输出.因此，如果使用多个合并联接，则必须使用排序转换，这当然会影响性能.

查找 有时可以类似于合并联接的方式用于数据匹配.

The Merge Join transformation provides an output that is generated by joining two sorted datasets using a FULL, LEFT, or INNER join. So if you are using multiple merge join then you have to use sort transformation and of course it will affect performance.

Lookup can sometimes be used in a similar manner to Merge join for data matching.

这篇关于SSIS数据流任务在合并联接后删除完全块排序的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！