This can be achieved in the following three steps :- 1) Expression transformation :- use a iff condition to define the columns with the particular string and where err_cd=0 2) Aggregator : …

Informatica itself and user base always recommend to use Sorter and then use Aggregator transformation with sorted input to achieve good performance. I would like to know why, …

Hi , In the Informatica documentation for the aggregator I see the following : When selecting multiple group by ports in the Aggregator transformation, the Integration Service uses port …

What can be the scenario where I can use aggregator transformation without using any group by on any of the port. For ex consdier ID SAL 1 1000 2 2000 3 3000 4 4000 How can I calculate …

I was avoiding Aggregator Transformation and Function thinking it would slow down the performance looking into the number of records. Please suggest the best approach to achieve …

Aggregator - GroupBy In an aggregator, if you do NOT have 'Sorted Input' selected and input to the aggregator is not sorted, will the output from the aggregator be ordered (sorted) by the …

Aggregator transformation without selecting group by clause!! If we ignore to select group by clause in an aggregator transformation ,what will be the output?

D, 1 Now pass the output of expression transformation, aggregator transformation to joiner transformation and join on the products port. In the joiner transformation check the property …

Aggregator transformation is an active transformation used to perform calculations such as sums, averages, counts on groups of data. The integration service stores the data group and row …

To improve the performance of this operation, it is often suggested to turn the sorted input property on, and pass the output of a sorter transformation (with keys = group by ports) to the …