Hi All, As seen in above picture, I am supposed to take the date for an Order where Version column is highest. For example in above scenario I should be taking the Date in second row since Version 2 is …

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 …

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?

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 …

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

> 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 , 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.

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 …

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 …