将不匹配的输出行发送到任何地方 [英] Sending no match output rows to nowhere

问题描述

有没有办法将 Lookup No Match 输出重定向到nowhere"?我们的业务需求不需要这些情况的匹配输出，并且当我不将它们重定向到转换时我会收到警告.

Is there a way to redirect Lookup No Match output to "nowhere"? Our business requirements do not require no match output for these cases, and I receive warnings when I don't redirect them to a transformation.

注意:忽略不匹配是不行的，因为返回空值并且表不接受空值.

Note: Ignoring the no match will not do since NULLs are returned and the table does not accept nulls.

感谢您的时间.

推荐答案

我发现将派生列转换重命名为位桶"是处理此类场景的绝佳目的地.

I find the Derived Column transformation renamed to "bit bucket" to be an excellent destination for scenarios like this.

社区中的其他人出于同样的目的是 垃圾目的地(滚动到底部)的粉丝.

Others in the community are fans of the Trash Destination (scroll to the bottom) for the same purpose.

这篇关于将不匹配的输出行发送到任何地方的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！