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 is sq transformation?
How we can use union transformation?
can u any challenge your project?
What are Dimensional table?
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
Mention few advantages of router transformation over filter transformation.
What does command task mean?
What does reusable transformation mean?
Tell me about Propagate functions in informatica
State the differences between sql override and lookup override?
Briefly define a session task?
What is Cognos script editor?
What are junk dimensions?
What could be the possible resons of locks by user?
What is the need of etl tools?