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 …

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

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 …

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 …

Feed this input into an Aggregator without any Group-By port and one output port with the expression Count (*) Then this AGG will output the value 3. And this is the result of SELECT COUNT ( …

Hi , Sorted input reduces the amount of data cached during the session and improves session performance.so working of sorter before aggregator is a best practice.

aggregator create one out put port and use max (Address) with out using this also you will get desired out put Why is this ? in a table col1 col2 col3 select col1 from table group by col2,col3 This wont …

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 …

Enable distnict option in the sorter which will give the distinct output to aggregator,then use count function on ID column ,then you will get the unique record count