What is the Difference between sorter and aggregator?
- 2 Answers
- 7714 Views
- I also Faced
- E-Mail Answers
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 |
Implementation methodology
State the differences between sql override and lookup override?
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?/
how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?
Hello, I have the below table: CityID CityName CostOfLiving 1 Mumbai 5000 1 Bangalore 4500 1 Chennai 4800 2 Vapi 6000 3 New Delhi 8000 I am passing the rows of the above table through the aggregator transformation in Informatica What happens in the following conditions: 1) I specify no group-by ports? 2) I specify a group-by on CityID without making any separate post for aggregation? Which city and costofliving will this eventually take for CityID=1? 3) Rest being same as point 2,I take the sum of cost of living.Which city will be returned for ID=1? Thanks for your help!
Please let me know how to do estimation before staring development in project. Here estimation in the sense how many associates are required, etc to complete the project.
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
what is the size of u r project? and what is the size of source file?
What are Business Components in Informatica?
How to display null values on a target & non-null values on a target?
Enlist the various types of transformations.
Teradata 
