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

Aggregator outputs last row Hi, I was asked a question on aggregator transformation that I didn't know answer for so I thought I will ask here to see if someone can help. Why aggregator outputs last row …

Aggregator transformation without selecting group by clause!! If we ignore to select group by clause in an aggregator transformation ,what will be the output?

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.

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 but after the …

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

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 …

How sorter helps aggregator transformation I know sorted input helps aggregator transformation for performance. But I m not getting how it will help? If you don’t use sorter before aggregator …

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