Interested to Buy Any Domain ? << Click Here >> for more details...
All active transformations r passive or not?
- 7 Answers
- 11787 Views
- I also Faced
- E-Mail Answers
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 |
Performance wise which is better joiner or look up ? Give me with example?
can you avoid static cache in the lookup transformation? I mean can you
what is session override?
In a scenario I want to change the dimensions of a table and normalize the denomralized table which transformation can I use?
How to load last 10 records of flat file in to the target?
Suppose we are using a Dynamic Lookup in a Mapping and the commit Interval set for the tgt is 10000. Then how does the data get committed in the lookup if there were only 100 roows read from the src and the dynamic lookup dint have the 100th row in it?
A session S_MAP1 is in Repository A. While running the session error message has displayed
What are two types of processes that informatica runs the session?
What are the differences between source qualifier and joiner transformation?
How to extract sap data using informatica?
What is difference between a connected look up and unconnected look up?
suppose i have 1000 records and i want to load half of the record in target 1 and half in target2.how u'll do?
Teradata 
