Interested to Buy Any Domain ? << Click Here >> for more details...
What is the Difference between sorter and aggregator?
- 2 Answers
- 8823 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 |
What is the difference between sequential batch and concurrent batch and which is recommended and why?
What are the databases that informatica can connect to windows?
what are the limitations of pushdown optimization technique ? Advance thanks
how do u move the code from development to production?
what is data driven?
Which kind of index is preferred in DWH?
On which transformations you created partitions in your project?
What is the use of target designer?
If we use sorted ports in aggregator transformation and somehow records are not in order by format so what will happen,session fails or it succeeded with incorrect data?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
Is it any possible to using more than one port in Unconnected Lookup Transformation( :LKP.LKP_Prod(Prod_GRP ,Prod_DT,Prod_TM) ) Like this? Pls explain...
what is distinct
Teradata 
