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
how to load dimension table and fact table. plz tell me the steps.
What is a connected transformation?
What is mapplet in informatica?
how many types of dimensions are available in informatica?
What is informatica worklet?
How do you set a varible in incremental aggregation
How you can differentiate between connected lookup and unconnected lookup?
What is a joiner transformation and why it is an active one?
What is parallel processing in informatica?
How would you join a node to the already existing domain?
What could be the possible resons of locks by user?
What are mapplets?
Why do you use Mapping Parameter and mapping variable?
While migrating the data from one environment to another environment how would you manage the connections?
State the limitations where we cannot use joiner in the mapping pipeline?