All active transformations r passive or not?
Answers were Sorted based on User's Feedback
Answer / bsgsr
every transformation is passive by default since they dont
have any default condition. they become active only when a
condition is added.
Is This Answer Correct ? | 7 Yes | 1 No |
Answer / chow
In my view all t/rs r passive.Depending upon the using t/rs
u can say it is passive or not.For ex what kalyani saying
about filter t/r(it is a active).ok
Suppose i have a source with 10 records in 10th
department.And i give a condition in filter as deptno=10.In
this situation filter recieve 10 records and passes 10
records.
In this situation filter is active?
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / vishnu
My answer would be like in the case of filter t/r if the c ondition is not mentioned then the default condition is true i.e., all the records from the source r moved to the target in this situation filter t/r acts as passive.
suppose in aggregator t/r if we r not mentioned any group by port then last record will be displayed in this situation it acts as active.So not all active t/rs are passive
Is This Answer Correct ? | 3 Yes | 0 No |
Answer / kalyani
An active transformation can change number of rows that
pass through it, such as a
filter transformation that removes rows that do not meet
the filter condition
A passive transformation does not change the number of
rows that pass through it,
such as Expresion transformation that performs a
calculation on data and passes all rows
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / ganesh prasad
no
all active transformations r not a passive transformation
active transformation will change the no of rows at target
level.
but passive transformations cont change the no of rows at
target level
Is This Answer Correct ? | 2 Yes | 3 No |
Answer / saradhi
no all the active transformations are not passive even
though its give same no of records in source.
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / prasanthi
yes if a conditon is applied to a tranformation then only
we can say whether the no of rows will be change or not so
i say that all active tranformations are defaultly passive
Is This Answer Correct ? | 0 Yes | 2 No |
Diffrence between static and dynamic cache
Quickly characterize reusable change?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
explain abt union t/r?
How to load only the first and last record of a flat file into the target?
What are the differences between a connected lookup and unconnected lookup?
If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?
Parameter and variable differences
What are steps to follow Informatica migration from 7x to 8x? Pls Explain...
Work flow failed when it is set to Bulk mode but it was successful when set to normal mode y??(All the connections are fine and exactly correct)?
How do you join more than 3 flat files in informatica?
How u use pdf file in informatica source?