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
Hi, I want to do Informatica Designer certification. Can anyone help me by providing the details on this. Thanks in advance. Regards, Arnab
r u done any partitions in ur project?
What do you mean by worklet?
explain one complex mapping with logic? sales project?
Repository user profiles
What is complex mapping?
Differentiate between a database and data warehouse?
Explain the different kinds of facts.
What is fact table? Explain the different kinds of facts.
How will the document be delivered to me?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?
What are the differences between joiner transformation and source qualifier transformation?
Mention few advantages of router transformation over filter transformation.
Can informatica load heterogeneous targets from heterogeneous sources?