对具有不同列的目标使用多播转换 [英] 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 显示
Source
有两列 Header 和 Value. - 屏幕截图 #2 显示
Destination 1
包含 Header 和 Value 列.它们被相应地映射. - 屏幕截图 #3 显示
Destination 2
只有 Header 列.它被相应地映射. - 屏幕截图 #4 显示了示例包执行.
- Screenshot #1 shows that
Source
has two columns Header and Value. - Screenshot #2 shows that
Destination 1
has both columns Header and Value. They are mapped accordingly. - Screenshot #3 shows that
Destination 2
has only column Header. It is mapped accordingly. - Screenshot #4 shows sample package execution.
希望有所帮助.
屏幕截图 #1:
屏幕截图 #2:
屏幕截图 #3:
屏幕截图 #4:
这篇关于对具有不同列的目标使用多播转换的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!