安裝中文字典英文字典辭典工具!
安裝中文字典英文字典辭典工具!
|
- 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
- Use Aggregator or Sorter for distinct rows? - Informatica
Hi, I need to get the distinct rows in the mapping It is in between 2 transformations in the middle of the mapping No of rows being passed is around 1,00,000 I can use Aggregator Sorter to get the distinct rows But which one is better for this requirement? Why? Please explain if one performs better than the other and why? Thanks, Prasanna
- 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?
- Order of evaluation of variable ports in Expression or Aggregator . . .
In other words, are there cases where variable ports within an Expression or an Aggregator are NOT strictly processed from top to bottom? If so, how can this feature be disabled?
- 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
- 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
|
|
|