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

tell me 5 session failure in real time how can you solve that in your project?

1849


list out all the transformations which use cache?

855


What are the modules in Power Center

1391


How to update source definition?

822


Write the program through which the records can be updated?

714






in reporting we add some new objects,how we get the count of the newly added objects to the report

1949


What is sq transformation?

831


How to extract sap data using informatica? What is abap? What are idocs?

768


What are connected or unconnected transformations?

816


What is the difference between Active and Passive transformation?

819


Explain the etl program with few examples.

717


What is meant by a domain?

821


What is decode in informatica?

796


What is the sequence generator transformation in informatica?

833


Why union transformation is an active transformation?

826