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
Typo error in my previous post.
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 Aggregation Transformation is sorted.
Regards,
Kumar
| Is This Answer Correct ? | 11 Yes | 0 No |
Post New Answer View All Answers
Describe the impact of several join conditions and join order in a joiner transformation?
What is a repository? And how to add it in an informatica client?
What is domain and gateway node?
What is a repository manager?
what are factless facts? And in which scenario will you use such kinds of fact tables.
Can you use flat files in Mapplets.
Differences between connected and unconnected lookup?
Explain the features of connected and unconnected lookup.
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?
Explain the tuning lookup transformation - informatica
What all join we can perform in LOOKUP transformation?
What is meant by active and passive transformation?
What are the transformations that are not supported in mapplet?
Explain the informatica workflow?
How an expression transformation differs from aggregator transformation?