What is the Difference between sorter and aggregator?
Answers were Sorted based on User's Feedback
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 |
Answer / dkr
Sorter uses the sorter Algorithm, but Aggrigator uses a
physical Algorithm -(called CLUSTERED Algorithm)
| Is This Answer Correct ? | 1 Yes | 3 No |
What are the scheduling options to run a sesion?
in which situations do u go for sequence generator ?
how may sources can be used in a mapping at a time?(limit)
Give some information on report bursting and how to do it in bca as I have to split the report and send different reports to different people?
When will u go for (which means situation) Connected Lookup and Connected Lookup? Pls explain with an example?
What are the main features of Oracle 8i with context to datawarehouse?
How to Join Tables my Source is having 15 table target is one?
What is main use of mapplet?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is the internal processes of integration server in Informatica? How data will be extract and load to the target?
Define pmcmd command?
What is the sql query overwrite in source qualifier in informatica