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.?
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
What is workflow? What are the components of the workflow manager?
What is a sorter transformation?
Can we create two repositories on same database instance in oracle?
Can we create a Integration service without a Repository service and vice versa?
What is the need of an ETL tool?
Explain the features of connected and unconnected lookup.
How can we remove the duplicates from flat file source?
what is the Default Source Option For Update Strategy Transformation?
How you prepared reports for OLAP?
Parameter and variable differences
Define enterprise data warehousing?
Under which circumstances, informatica server creates reject files?
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
COM components can be used in Informatica
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?