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

When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,


what is mapping performence?

2 Answers   Cap Gemini,


What the difference is between a database, a data warehouse and a data mart?

0 Answers  


Informatica and datawarehousing courses in Pune?

2 Answers  


Debugger what are the modules, what are the options you can specify when using debugger, can you change the expression condition dynamically when the debugger is running.

0 Answers  






If there are 3 workflows are running and if 1st workflow fails then how could we start 2nd workflow or if 2nd workflow fails how could we start 3rd workflow?

4 Answers   TCS,


Is it possible to define a single node as a Gateway node as well as worker node?

0 Answers  


What is limitations of truncate and load option

1 Answers   Cap Gemini,


What is source qualifier transformation?

1 Answers  


How the dimensions will be loaded?

0 Answers   HCL,


can any one explain about dataflow in the informatica project for bank domain....thanks is advance

0 Answers   IBM,


Enlist the differences between database and data warehouse.

0 Answers  


Categories