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

differences between service based and product based?

0 Answers   Satyam,


What are the components of workflow manager?

0 Answers  


How can u stop a batch?

2 Answers  


How will u pas the data with out debugger?

4 Answers  


When we are using Dynamic Cache,which options we will select in session level?

1 Answers   Cognizant, CTS,






HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?

6 Answers  


As per Informatica PC help guide, while adding transformations to a mapplet,we have to keep this in mind: If you use a Sequence Generator transformation, you must use a reusable Sequence Generator transformation. May i know the reason behind this?

2 Answers  


there is a mapping with expression and mapping we create some condition for insert and update and followed by update startegy ,can we update and insert on a single target based on condition?

1 Answers   Emphasis,


why do we go for update strategy tr in SCD rather using the session properties?

3 Answers   IBM,


What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?

0 Answers   CTS,


How can you change from reusable session into non-reusable session.

5 Answers   Cap Gemini,


What is the Difference between PowerPlay transformer and power play reports?

1 Answers  


Categories