to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?
- 3 Answers
- 7922 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / bhupal
if u wont use the sorted input the aggregator transformation will reads the records and keep until all the calculations are done.
if we provided the sorted input it reads the records and release the records reaching next first record of new group.
the integration service will creates the cache for only the sorter keys and only one cache in sorter t/r. so by providing the sorted input we get the performance advantage.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
can we override a native sql query within informatica? How do we do it?
How can we use mapping variables in informatica?
I want my deployment group to refer an external configuration file, while i deploy in the production environment. How can i achieve it.
What is a connected transformation?
What is decode in informatica?
What is a stored procedure transformation?
What do you mean incremental aggregation?
Hi, I want to change date type char value integer value? I tried alter table tab_name modify (newcolumn newdatetype). But The columns have 10 million values(char type) so I want to load now numeric data. How it is possible? Old Values New Value(I want to load numeric data but the old value should be there in the column) Y 1 N 0 ERROR at line 1: ORA-01439: column to be modified must be empty to change datatype Please help on this. Thanks, GM
What is lookup change?
What are data-driven sessions?
How to update source definition?
What is a shortcut and copy in Informatica and how two are different with each other?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is rank index in rank transformation?
What all join we can perform in LOOKUP transformation?
