Interested to Buy Any Domain ? << Click Here >> for more details...
All active transformations r passive or not?
- 7 Answers
- 11508 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 |
WHAT IS USE OF SQL OVERRIDE IN SOURCE QUALIFIER? chandumba2005@gmai.com
in mapping i have one source and five targets in that data will be loaded into four targets properily in one target the data is not loaded how will u rectify
How will you update the row without using update statergy?
Where should yoU place the flat file to import the flat file defintion to the designer?
why do we go for update strategy tr in SCD rather using the session properties?
What is a node in Informatica?
How can i generate Seqence Numbers to Tagret Table (with out using Seqence Gen Trans,Rank Trans).
What is dimensional table?
Tell me about MD5 functions in informatica
How did you handle performance issues If you have data coming in from multiple sources, just walk thru the process of loading it into the target
What is a snowflake schema?
Write the program through which the records can be updated?
Teradata 
