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 / 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 |
differences between service based and product based?
What are the components of workflow manager?
How can u stop a batch?
How will u pas the data with out debugger?
When we are using Dynamic Cache,which options we will select in session level?
HOW CAN I SEND HALF OF THE RECORDS TO ONE TARGET AND REMAINING TO OTHER TARGET?
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?
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?
why do we go for update strategy tr in SCD rather using the session properties?
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 ?
How can you change from reusable session into non-reusable session.
What is the Difference between PowerPlay transformer and power play reports?