We can achieve better perfomance using sorter before an
aggragator. Then what is the significance of 'Sorted Input'
check in aggregator ?? Please let me know the difference ??

Answers were Sorted based on User's Feedback



We can achieve better perfomance using sorter before an aggragator. Then what is the significance o..

Answer / guest

Typo error in my previous post.

Integration service is not intelligent enough to know the
data is sorted. So If "Sorted Input" Option is checked,
then Integration service understands that the input data to
the Aggregation Transformation is sorted.

Regards,
Kumar

Is This Answer Correct ?    11 Yes 0 No

We can achieve better perfomance using sorter before an aggragator. Then what is the significance o..

Answer / guest

Integration service is not intelligent enough to know the
data is sorted. So If "Sorted Input" Option is checked,
then Integration service understands that the input data to
the sorter Transformation is sorted.

Regards,
Kumar

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Informatica Interview Questions

In how many ways we can create ports?

0 Answers  


What are the types of caches in lookup?

0 Answers  


What is diff between connected and unconnected lookup?

5 Answers   BirlaSoft, Blue Star Infotech,


difference between informatica 8.6 and 9

3 Answers   Atos Origin, BA Continnum Solutions, Core Logic,


How do you migrate data from one environment to another?

0 Answers  






Two different admin users created for repository are ______ and_______

1 Answers  


what is the method of error handling when session is running?

1 Answers   TCS,


what is the use of Java Transformation in Informatica 8.x?

2 Answers   TCS,


Using Connected or unconnected lookup for performance wise which one is preferable?.

1 Answers   Deloitte,


in flatfile target how can u create header and footer plese give me the comands how will u write in session properties

3 Answers   Patni,


What is the reusable transformation?

0 Answers  


tell me 5 session failure in real time how can you solve that in your project?

0 Answers   CSC,


Categories