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 |
how can u approach u r client
Difference between task flow and linear task flow
What are the modules in Power Center
How to load the data into target table, which not have Primary/Surrogate key (Duplicate records not acceptable)
Two relational tables are connected to SQ Trans,what are the possible errors it will be thrown?
.prm wirh repalce .txt is possible?
how to construct simple biogas digerter? please show me detail drawing and specification of simple biogas construction?
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
Hi, I have one flatfile as target in a mapping . When i am trying to load data second time into it. The records already is in flatfile is getting override. I don't want to override existing records. Note : we can do this by implementing CDC / Incremental pool logic if target is relational . But this is flatfile. So, even i use this same technique it will override only So what is the solution ? Is there any option at session level for flatfile target ? Advance Thanks
in informatica,if i have some no.of records,if i want 1st and 10th records..what will be the method to use?
write a query to get maximum salary from the employers table without duplicates....kindly help me
can any one give some examples for pre sql and post sql(Except dropping and creating index).