Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8472 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / james
Sorted input in an aggregator transformation does not use
cache instead it uses the memory. Reading from memory is
faster than reading from cache.
| Is This Answer Correct ? | 0 Yes | 1 No |
Post New Answer View All Answers
Define Pmrep command?
update strategy transformation in informatica
What is enterprise data warehousing?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What all join we can perform in LOOKUP transformation?
Scheduling properties,whats the default (sequential)
What does refresh system mean, and what are its distinctive choice?
What is a grid in Informatica?
Why update strategy and union transformations are active?
How can one identify whether mapping is correct or not without connecting session?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
suppose we are using dynamic lookup cache and in lookup condition the record is succeeded but in target it is failed due to some reasons then what happened in the cache ?
expain about the tune parameters?
Which files are created during the session rums by informatics server?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
