How can yoU improve session performance in aggregator
transformation?

Answer Posted / dilip

if you sort the input yet do not select the sorted input
option, the aggregator treats the data as unsorted data &
performs the task hence its cache size increases. the
performance is degraded despite using a sorter.

Is This Answer Correct ?    8 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

difference between repository database and repository service?

630


How you can differentiate between connected lookup and unconnected lookup?

619


What is informatica?

686


Informatica settings are available in which file?

593


Briefly describe lookup transformation?

603






Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

736


Explain the shared cache and re-cache?

617


What is the use of source qualifier?

679


Enlist the various types of transformations.

562


What is a shortcut and copy in Informatica and how two are different with each other?

688


What is the surrogate key?

644


If i have source as flat file. how can i store the header and trilor into one target and data into one more target. |------>target1(header+trailor) source------ |------>target2(data) can any one please help me

1560


Differentiate between a repository server and a powerhouse?

583


What is substr in informatica?

665


What do you mean by channel change?

550