If we use sorted ports in aggregator transformation
and somehow records are not in order by format so what
will happen,session fails or it succeeded with incorrect data?

Answer Posted / akhil4

session will be failed,when ever u enable the sort ports option u can use "sorter transformation" before "aggregator trns" that time session will be run.

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many ways are there to create ports?

736


Describe expression transformation?

646


What is informatica powercenter repository?

725


Explain target update override in informatica

642


What is depict expression change?

636






What is source qualifier transformation in informatica?

586


Explain the difference between a data warehouse and a data mart?

608


what is Active lock explain

2382


Explain why we use partitioning the session in informatica?

626


On which transformations you created partitions in your project?

769


Differentiate between a database and data warehouse?

664


How to create or implement slowly changing dimension (SCD) Type 2 Effective Date mapping in informatica/Flagging mapping in informatica/visioning mapping in informatica?

724


write sql query vertical to horiozontal following table id name 1 100 2 dinesh 3 india 1 101 2 suresh 3 india 1 103 2 prakesh 3 usa i want output like id name country 100 dinesh india 101 suresh india 103 prakesh usa

2085


How many ways are there to do 'remove duplicate records in informatica'?

597


What is difference between a gateway node and worker node?

637