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
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
Describe data concatenation?
What do mean by local and global repository?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is a transaction control transformation?
What is dynamic cache?
Write the unconnected lookup syntax and how to return more than one column.
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How do you update the records with or without using update strategy?
How we can use union transformation?
How can informatica be used for an organization?
How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?
What is decode in static cache?
Explain lookup transformation in informatica
What is a repository manager?