How to take a record based on MAX value of a column
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 …
How to Load First and Last records from Flatfile source...
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 …
How to remove duplicates in Flat files. - Informatica
> 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 - Informatica
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 …
How to transfer all unique rows to 1 target and all ... - Informatica
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 …
Aggregator - sorted input - Informatica
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, technically. …
how to count distinct - Informatica
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 …
Aggregator : Group order can affect the results
Hi , In the Informatica documentation for the aggregator I see the following : When selecting multiple group by ports in the Aggregator transformation, the Integration Service uses port order to determine …
aggregator transformation placed after update strategy transformation
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 …
Aggregator - GroupBy
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?