What is the Difference between sorter and aggregator?

Answers were Sorted based on User's Feedback



What is the Difference between sorter and aggregator?..

Answer / giri

Sorter Aggregator
------- -----------
1.Asc and Desc Only Asc order purpose
order purpose
2.Query is not Passible query is passible

Is This Answer Correct ?    2 Yes 0 No

What is the Difference between sorter and aggregator?..

Answer / dkr

Sorter uses the sorter Algorithm, but Aggrigator uses a
physical Algorithm -(called CLUSTERED Algorithm)

Is This Answer Correct ?    1 Yes 3 No

Post New Answer

More Informatica Interview Questions

Is informatica power center designer has 64 bit support?

1 Answers  


how to improve performence by using sorted input in aggrigator t/r.

2 Answers  


which is better perfomancewise lookup or joiner and why?can anyone give example?

6 Answers   TCS,


What are the tuning techniques you applied during your last project

0 Answers  


What are the new features of informatica 9.x in developer level?

0 Answers  






111111111111ravi11111111kumar11111111111? i want display ravi kumar using sql?

3 Answers   IBM,


i have flat file it contains 'n' number of records, i need to send half of the records to one target table and Remaining half to another target table. can any tell me procedure.

2 Answers   TCS,


What is up date strategy and what are the options for update strategy?

2 Answers  


Hi, If any hav Informatica n DWH FAQ's,Plz do fwd to vanibv6@gmail.com Thnx Vani

1 Answers  


Define sessions in informatica etl?

0 Answers  


suppose we will take flatfile target and load type is bulkload the session fails why please give me the answer

1 Answers   TCS,


What is aggregate cache in aggregator transformation?

0 Answers   Informatica,


Categories