-
Passive Router Transformation
Router is passive transformation, but one may argue that it is passive because in case if we use default group (only) then there is no change in number of rows. What explanation will you give?
Read Best Answer
Editorial / Best Answer
sasi.a.kumar- Member Since Aug-2009 | Aug 14th, 2009
Router is an Active Transformation, Most of the time we use router only when we are going to apply multiple conditions on a records, It is absolutely possible for a record to satisfy one or more conditions thus making the router Active, Router is the only active transformation where the number of output records from the transformation is greater or equal to the number of input records given to the transformation.
bosna
- Aug 17th, 2011
AS PER INFORMATICA DOCUMENTATION, Router transformation is ACTIVE and CONNECTED.. Please Don't thumb down if you're not sure..
RANJAN RASMI DAS
- Jan 12th, 2011
Router can act both active and passive, one example....Suppose in source we have recordsid.....name -----------10.....aa10.....bb20.....cc20.....dd30.....xx40.....yy We have one target table...
-
Is the order in which the conditions are given in the 'WHERE' clause are important?
Mean I heard from Oracle 8i onwards the order of where clause condition does not matter which oracle creates the explain plan...and execute..Is it true?
manoj_behera82
- Aug 7th, 2008
Yes the order is important. But it is important for the performance of the query and not for the final result. The output of the query will be the same irrespective of the order in which the join con...
gtomar
- Aug 7th, 2008
Hi, Where Clause conditions execution are independent of order in explain plan but it reads top to bottom.Thanks,Gunjan
-
How can I use multiple filter transformations? How do I pass dropped rows to next filter transformation to check the conditions?
Rajarao marisa
- May 31st, 2012
Ok its not good work environment by using multiple filter t/r usage Any way by using multiple filter we can load rejected rows also SD-->SQ-->fltr(condition(true)(eg:deptno=10)---->loaded into one tar...
srinuraj
- May 31st, 2010
You can use filter transformations to filter rows. Filter transformations passes rows to next transformation which rows met the condition. But it cannot pass rows which rows doesn't meet the condition...
-
what is the difference between source qualifier transformation and filter transformation?
manoj_behera82
- Nov 9th, 2009
Basically source qualifier is a representation of the records that Informatica server reads when it runs the session. It is associated with a source can be a table or flat file as well. It is capable ...
divakar
- Nov 5th, 2007
A Source Qualifier transformation is the starting point in the mapping where in we are bringing the incoming data or the source data is extracted from this transformation after connecting to the ...
-
How can U improve session performance in aggregator transformation?
Use sorted input.
manoj_behera82
- Jul 20th, 2010
1. Provide sorted input into the aggregator. Do check the sorted input property in the aggregator.2. Reduce the input/output ports in the aggregator.3.Can try increasing the cache size.
job_infa
- Jan 28th, 2009
-Use sorted input to decrease the use of aggregate caches.-Limit connected input/output or output ports.Limit the number of connected input/output or output ports to reduce the amount of data the Aggregator transformation stores in the data cache.-Filter the data before aggregating it.
