Aggregator - adding condition in aggregator expression This can be achieved in the following three steps :- 1) Expression transformation :- use a iff condition to define the columns with the particular string and where err_cd=0 2) Aggregator :-Then use the aggregator and use count (*) to count the columns based on err_cd=0 which we have separated befor the aggregator This is just a basic code depending on what u have asked So this execution plan
Sort option in Aggregator Transformation for null rows I am redirecting the output of source qualifier into aggregator transformation with SORTED INPUT option enabled and for NULL values present in city_name, i am using default value as 'INDIA'
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 If, sorted input is not given, Aggregator, anyway, does the sorting and then aggregating How come it is anyway, different from doing the explicit sorting and then aggregator (with sorted input) than
Aggregator - GroupBy - Informatica 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?
Aggregator Tranformation without groupby port Hi Team, If we use aggregator tranformation without checking any port as group by, what will happen? Source: ENo,Ename 414,Giri 4059,Jana 144,Mohan Source->Source Qualifier->Aggregator (no port selected group by)->Target Appreciate in advance for your help here Thanks, K Giridhar
Calculate count (*) without using aggregator transformation I was avoiding Aggregator Transformation and Function thinking it would slow down the performance looking into the number of records Please suggest the best approach to achieve my task
) How to return First Last record via one Aggregator Transformation . . . <p>Please help me out on this?< p> Let's take an example case where you have three input ports to the AGG, namely FULL_NAME (String (60)), ZIP_CODE (String (5)), and ADDRESS (String ( 40)) Now set up six output ports in your AGG like this: O_FIRST_FULL_NAME (String (60)): FIRST ( FULL_NAME) O_LAST_FULL_NAME (String (60): LAST ( FULL_NAME) O_FIRST_ZIP (String (5)): FIRST ( ZIP_CODE) O_LAST_ZIP
working of Sorter before Aggregator? 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
Aggregator Transformation output fields Hi, i have question about aggregator t f, i have 4 columns say A,B,C,D and Grouping by column A and calculation is on column B like Max (B) then when i am mapping
Aggregator without any group by - Informatica What can be the scenario where I can use aggregator transformation without using any group by on any of the port For ex consdier ID SAL 1 1000 2 2000 3 3000 4 4000 How can I calculate count (*) without using group by clause in aggregator transformation ? I need to use aggregator transformation only Any help would be highly appreciated