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

Diffrence between 7.1,8.1 and 8.6

3 Answers   HCL, Wipro,


what transformations are used for Variable port?

2 Answers  


In session log thier should not be a single error how will u do

3 Answers   HCL,


Differentiate between reusable transformation and mapplet.

0 Answers  


what is casual dimension?

6 Answers   IBM,






what is mapping override?

2 Answers   Cap Gemini,


What are the mapping paramaters and mapping variables?

1 Answers  


Write the prerequisite tasks to achieve the session partition?

0 Answers  


when we use lookup,if have 5 records,if i dont need 1st and 2nd records..what will be the procedure to achieve by using lookup?/

5 Answers   L&T,


what is galaxy repository?

2 Answers  


i have two source data there is no pk,fk how to join the two sources

5 Answers   TetraSoft,


How to delete duplicate record in Informatica?

7 Answers  


Categories