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 option in Sorter, all the ports will consider as key ports So > Put one Aggregator and select the Group By for one column > You can also use unix command i e sort and uniq in
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 when you do not select any groupby port What is the logic behind this? This was the exact question asked Thanks Rajni
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 way in Informatica Thanks in advance
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 input, then only you can connect both expression and aggregator to joiner transformation The output of joiner will be product, O_dummy, O_count_of_each
How to load last three rows using Informatica 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->V_Rowid+1 O_Rowid->V_Rowid Aggregator:No port is checked for group by, O_Dummy_Port->Count (Primary key Port) FIlter:O_Dummy_Port-O_Rowid<3 If I use like this I am getting only last row but not last three rows
How to add sum of values? - Informatica While you are processing the input records, you sum up all individual values using an Aggregator transformation without Group-By ports; this makes sure that the AGG will deliver the sum over all values, not only for any particular group of records Now you have to somehow attach a last line to the target file with this value