if we r using aggregator we enabled sorted input but the
records r not sorted what happen?
Answer Posted / krishnakanth.ch
When the 'Sorted Input' is enabled and if the data is not
sorted, then unexpected results will occur. It means the
session will succeed but the end result may not be the way
as per the business requirement.
Another point to be remembered is:
Group by columns in the Aggregator transformation must be
in the same order as they appear in the Sorter
transformation
| Is This Answer Correct ? | 3 Yes | 3 No |
Post New Answer View All Answers
What are the different ways to implement parallel processing in informatica?
How can we improve session performance in aggregator transformation?
How many ways are there to do 'remove duplicate records in informatica'?
Write the unconnected lookup syntax and how to return more than one column.
How can we use batches?
Is it possible to define a single node as a Gateway node as well as worker node?
What are the static cache and dynamic cache in informatica?
What are the uses of etl tools?
Explain the scenario which compels informatica server to reject files?
What is the session task and command task?
can anyone suggest best free Talend data integration training online
Explain what is informatica metadata and where is it stored?
What is an expression transformation in informatica?
What is the difference between writing a joiner query in ANSI style and THETA style?
What is informatica etl tool?