New Informatica support forum

Hey… Informatica have launched a brand new set of discussion forums on their website. This url should normally point to the overview .

I have a good feeling about this, the company hosting its own discussion forums. Before this there were some yahoo groups that acted as discussion forums for the company, and some developer network forums.

See how it goes…

Aggregator : Sorted Input

You would read everywhere that an aggregator responds faster if you provide it sorted data. Yeah, thats correct in theory.

But, be careful while doing that. If you decide to use Sorter transformation to sort data, the end result might be slower. However, another option is to use sorting at the source qualifier level..

In one of my experiments on Powercenter 7.1.3, I had the following stats :

Source Data : 277000 rows
time for an aggregator :

No sorted input : 22 seconds
With sorter in mapping : 50 seconds
With sorting in Src Qualifer : 16 seconds

My view is, if possible, do the sorting at db end.