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

Explain what are the different types of transformation available in informatica.

786


1)you have multiple source system where u receive files ,how do you actually load into mapping using transformation,what are the transformation you use? 2)you have files in ftp location ,how do you get it into mapping with you ETL concept?

1904


What is a transaction control transformation?

968


What are the uses of etl tools?

869


What are the types of caches in lookup? Explain them.

755


Different qualification between a related rotate toward the sky and isolates look upward?

775


can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.

3622


Where can we find the throughput option in informatica?

844


How to generate or load values in to the target table based on a column value using informatica etl tool.

837


How to improve the performance of a session using sorter transformation?

925


What are the components of workflow manager?

806


hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica

1874


What is mapping debugger?

756


What is the maplet?

809


Explain lookup transformation in informatica

832