Aggregator | search
Click here to view Aggregator news from 60+ newspapers.
Bookmark or Share- aggregator transformation placed after update strategy transformationHi, It is said that if aggregator transformation is placed after the update strategy transformation, then if we flag a row for delete and then later use the row to calculate the sum, the integration service subtracts the value appearing in this row.But what is the necessity of performing the sum on those records flagged for delete and then later subtract it.
Also, it should ...
- How to Remove Duplicates from a Flat File Without Using Sorter and ...Hi All, Some body asked this question in ITtools site.I am expecting different ways of doing this. How to remove duplicate through mapping? a b c a a b d Source is flat file, remove duplicates without using sorter and aggregator transformation in Informatica.
- Reusing Joiner and aggregator caches - network.informatica.comI was wondering if there is a way I can reuse joiner and aggregator caches. Every time I am running the workflow, the index and data cache files are created and then deleted after the target tables are loaded. Is there a way, how I can improve the performance of my mapping. I have 15 joiners and 1 aggregator transformations in my mapping.
- Calculate count (*) without using aggregator transformationI was avoiding Aggregator Transformation and Function thinking it would slow down the performance looking into the number of records. But As you suggested that Aggregate Transformation without group by would not degrade the performance. So, what would be the best way to achieve it through Aggregate Transformation.
- Aggregator outputs last row - InformaticaThe answer for this is when ever you check the group by option aggregator will group by on the basis of that particular column. But when you don't do group by on a port then it thinks all the records as a group so returns the last value as we know if we do group by in informatica it gives the last record for all the groups. Hope it will help.
More
