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


Please Help Members By Posting Answers For Below Questions

Why update strategy and union transformations are active?

833


Explain the features of connected and unconnected lookup.

750


Differentiate between joiner and lookup transformation?

876


Enlist the advantages of informatica.

857


update strategy transformation in informatica

859


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

840


What are the main features of Oracle 8i with context to datawarehouse?

1892


Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure

6918


Can we change Dynamic to Static or Persistent cache? If so what happens?

1962


How to Create a folder using pmrep command?

860


Repository user profiles

1583


Do you find any difficulty while working with flat files as source and target?

903


draw informatica architecture 8.6 ?

3664


What is data movement mode in Informatica and difference between them?

877


What is standalone command task?

1040