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

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.

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

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 …

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 …

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.

Expand Post Digv.Bhos 11 years ago Hi Prasanna, I think in this scenario we should use sorted to get distinct records.Because to get distinct data from aggregator we need to select all ports as …

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 Gurus, I want to count distinct values for one column group by PK. can any body show me how to achive this in INFA. I can use select count (disitnct) in query, but just wondering if there is …

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