We can achieve better perfomance using sorter before an
aggragator. Then what is the significance of 'Sorted Input'
check in aggregator ?? Please let me know the difference ??
Answer Posted / guest
Integration service is not intelligent enough to know the
data is sorted. So If "Sorted Input" Option is checked,
then Integration service understands that the input data to
the sorter Transformation is sorted.
Regards,
Kumar
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
What is rank transform?
What are the validations that you can perform in oracle and in informatica ? Advance Thanks
What happens when a session fails and you click on recover?
What is meant by query override?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
How many ways are there to do 'remove duplicate records in informatica'?
What is enterprise data warehousing?
If I have 10 flat files with same name abc.txt files with different timestamps as source I need to load them in tgt table oracle. in between job execution fails and rows are not loaded into tgt. how can I make them load in that target even if my job fails?
How to generate sequence numbers using expression transformation?
what is $$$$?
Describe data concatenation?
What are the tuning techniques you applied during your last project
Explain pushdown optimization $pushdownconfig parameter - informatica
What are the tasks that can be performed using sq?
How to extract the informatica rejected data?