Interested to Buy Any Domain ? << Click Here >> for more details...
All active transformations r passive or not?
- 7 Answers
- 11761 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 the difference between SOURCE and TARGET BASED COMMITS?
HOW TO GET THE LATEST DATA IN SCD ?
How do you join more than 3 flat files in informatica?
Explain scd type 3 through mapping.
What do you mean by Parameter file? Why do we use it and what all things we can define in a parameter file?
What is the commit type if you have a transaction control transformation in the mapping?
How we can create indexes after completing the loan process?
Write the program through which the records can be updated?
Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me
explain abt joiner t/r?
Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR IN ORACLE & INFORMATICA LEVEL HOW TO ACHIVE
what is filelist concept in informatica
Teradata 
