信息学 9.1 : If you pass sorted input to Aggregator then does it gives sorted output or it's random?

Question

在 Informatica 9.1 未分区映射中，我使用的是排序聚合器，之后有一个连接器；我可以让我的 joiner 成为排序的 joiner 吗？
这里的问题是，如果您将已排序的输入传递给聚合器，那么从中获得已排序输出的机会有多大？

Answer 1

此类场景在高级转换指南中进行了讨论。请注意以粗体突出显示的点。

When you add transformations between the sort origin and the Joiner transformation, use the following guidelines to maintain sorted data:

• Do not place any of the following transformations between the sort origin and the Joiner transformation:

  • Custom

  • Unsorted Aggregator

  • Normalizer

  • Rank

  • Union transformation

  • XML Parser transformation

  • XML Generator transformation

  • Mapplet, if it contains one of the above transformations

• You can place a sorted Aggregator transformation between the sort origin and the Joiner transformation if you use the following guidelines:

  • Configure the Aggregator transformation for sorted input.

  • Use the same ports for the group by columns in the Aggregator transformation as the ports at the sort origin.

  • The group by ports must be in the same order as the ports at the sort origin.

• When you join the result set of a Joiner transformation with another pipeline, verify that the data output from the first Joiner transformation is sorted.

  Tip: You can place the Joiner transformation directly after the sort origin to maintain sorted data.