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
Can we use the mapping parameter or variables developed in one mapping into any other reusable transformation?
What are active and passive transformations?
Design a mapping to load a target table with the following values from the above source?
In What Situations we can use MappingParameters ,Mapping Variables AND Session Parameters in REAL TIME.
Mention few advantages of router transformation over filter transformation.
What is meant by LDAP users?
Explain is there any way to read the ms excel datas directly into informatica? Like is there any possibilities to take excel file as target?
How do you load alternate records into different tables through mapping flow?
What are the mapping parameters and mapping variables?
Write the unconnected lookup syntax and how to return more than one column.
How many ways are there to do 'remove duplicate records in informatica'?
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
What are the various types of transformation?
How to create a non-reusable instance of reusable transformations?
Can some one explain me about Telecommunications(wireless) project in Informatica? Thanks in advance