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?



If we use sorted ports in aggregator transformation and somehow records are not in order by format ..

Answer / 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

More Informatica Interview Questions

which T/r we can use it mapping parmeter and mapping variable? and which one is reusable for any mapping mapping parmeter or mapping varibale?

3 Answers   Wipro,


How i can Schdule the Informatica job in "Unix Corn Schduling tool" ?

2 Answers  


what is the mechanism of the Master-Detail joining condition?

6 Answers   IBM, Patni,


plz plz plz send client names and project names in informatica?

1 Answers  


List the transformation in informatica.

1 Answers   TCS,






guys which is the best institute in banglore to learn informatica??

2 Answers  


What is a standalone command task?

0 Answers  


Name 4 output files that informatica server creates during session running?

1 Answers  


SOURCE NAME SAL GANGA 30000 RAJU 20000 PAVAN 25000 TARGET NAME SAL MAXSAL GANGA 30000 30000 RAJU 20000 30000 PAVAN 25000 30000 in mapping level how to achive that

5 Answers   DELL,


What is A complex mapping?

3 Answers   TCS,


I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.

0 Answers  


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

2 Answers   CTS,


Categories