Aggregator | search
Click here to view Aggregator news from 60+ newspapers.
Bookmark or Share- Use Aggregator or Sorter for distinct rows? - InformaticaIf the Source is Falt file, the better to Use Sorter than Aggregator. Because you need to select all the columns groupby at Aggregator Transformation, so it takes more cache to perform and Performance degrades. Finallay Better to apply Sort on Numeric Column rather than String data if Possible. I think in this scenario we should use sorted to ...
- 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. Log In to Answer.
- TE_7041 Aggregate Error: Failed to allocate 249344 bytesApril 9, 2012 at 4:24 PM. TE_7041 Aggregate Error: Failed to allocate 249344 bytes. Hi Community, I've been using the Aggregator plugin for a while now for a number of functions, mainly for deduping. Right now I am trying to use it in a DSS task over approx 838K rows but get this error: TE_7041 Aggregate Error: Failed to allocate 249344 bytes.
- Aggregator - GroupBy - InformaticaWe use sorted input to the aggregator and enable the sorter option when we want to enhance the performance of the aggregator transformation. Since the sorted input will be more easily grouped by the group by option enabled. I understand the benefits of sorting and selecting 'sorted ports' but I wanted to know how the aggregator worked with no ...
- 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 ...
More
