Neelakanth_Patil a year ago Hi @Retroflame Aggregator will return the max value of date field, Just make sure you add correct group by columns.

Prad.Kann 10 years ago I found using the last function along with aggregator and joiner helps to identify the last record. I created two source definition reading from the same file. The first source reads all …

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 'GroupBy' ports?

> We can use ' Distinct ' property in Sorter Transformation to eliminate records from flat file or relational sources, but we can't use source qualifier SQL override for flat files. > But If you select the Disctinct …

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 sorted …

Hi Team, Can anyone help me how to load last three rows using Informatica? I have tried using in the below fashion Source->SQ->Expression->Aggregator->Filter->Target Expression:V_Rowid …

Like LikedUnlike Reply Sasi.Rame_33 13 years ago Hi Joe and Hi Anitha, The normalizer is used to convert the columns into rows .. If you want to convert the rows into columns ,we will use aggregator …

Hi, 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 …

For Aggregator, Joiner, Lookup, and Rank transformations, Data Integration creates index and data cache files to run the transformation. For Sorter transformations, Data Integration creates one sorter …

Aggregator Transformation behaviour Hi, I have some questions on aggregator transformations. Would you please help me in getting the below doubts cleared. 1) why aggregate functions not allowed in …