对具有不同列的目标使用多播转换 [英] Using Multi Cast transformation for destinations with different columns

问题描述

Multicast Transformation Task有什么用?通过此任务，是否可以从一个源发送到两个目的地，而每个目的地都有不同的列?

What is the use of Multicast Transformation Task ? With this task, is it possible to send to two destinations from a single source, while each destination has different columns ?

推荐答案

我假设您指的是数据流任务中的 Multicast Transformation.如果是这样，是的，这是可能的.转换的目的是将数据从单一来源引导至 n 个转换任务或目的地.

I assume that you are referring to Multicast Transformation inside the Data Flow task. If so, yes it is possible. The purpose of the transformation is to channel data from a single source to n number of Transformation tasks or Destinations.

如果来源有以下列

Source
Column 1
Column 2
Column 3

目的地有这些列.

Destination 1   Destination 2
Column 1        Column 2
Column 3

两个目的地都将能够看到源中可用的第 1 - 3 列.您必须在相应的目标中相应地映射列.请参考以下示例:

Both destinations will be able to see Columns 1 - 3 that are available in Source. You have to map the columns accordingly in the respective destinations. Refer below example:

示例:

1. 屏幕截图 #1 显示 Source 有两列 Header 和 Value.
2. 屏幕截图 #2 显示 Destination 1 包含 Header 和 Value 列.它们被相应地映射.
3. 屏幕截图 #3 显示 Destination 2 只有 Header 列.它被相应地映射.
4. 屏幕截图 #4 显示了示例包执行.

1. Screenshot #1 shows that Source has two columns Header and Value.
2. Screenshot #2 shows that Destination 1 has both columns Header and Value. They are mapped accordingly.
3. Screenshot #3 shows that Destination 2 has only column Header. It is mapped accordingly.
4. Screenshot #4 shows sample package execution.

希望有所帮助.

屏幕截图 #1:

屏幕截图 #2:

屏幕截图 #3:

屏幕截图 #4:

这篇关于对具有不同列的目标使用多播转换的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！