I have created a session in which I have added an aggregator. When I select the "Sorted Input" property, I get the following error:
ERROR: Partitioning option license required to run sessions with user-defined partition points.
Solution:
you need access to the Administration Console or you can ask you Informatica Administrator to set it for you.
For the Integration service, you are using, there are some Custom Properties that you can set (this property is at the bottom on the right side of the page for a given Integration Service you select on the left).
add a Custom Property "AggSupprtWithNoPartLic" with the value "Yes" .
When this parameter is enabled it will set the aggregator as a User Defined partition point so that the session will run successfully.
Also, then you can used the Sorted Input enabled in the Aggregator transformation.
使用UNION组件时出现上述问题,解决方法如下:
mapping中:
把union组件properties中required singer thread per partition默认的勾去掉
session:
把原先的session删掉,重新建session。
然后运行即可。