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
Explain what are the different types of transformation available in informatica.
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?
What is a transaction control transformation?
What are the uses of etl tools?
What are the types of caches in lookup? Explain them.
Different qualification between a related rotate toward the sky and isolates look upward?
can i any one explain me realtime healthcare project explanation..for interview .iam new to informatica .thanks in advance.
Where can we find the throughput option in informatica?
How to generate or load values in to the target table based on a column value using informatica etl tool.
How to improve the performance of a session using sorter transformation?
What are the components of workflow manager?
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
What is mapping debugger?
What is the maplet?
Explain lookup transformation in informatica