I still need further explanation about the difference
between active and passive transformation with some
examples.Thank You
- 5 Answers
- 7951 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / murali krishna
Transformations can be active or passive.
- An active transformation can change the 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 an Expression
transformation that performs a calculation on data and
passes all rows through the transformation.
| Is This Answer Correct ? | 11 Yes | 1 No |
Answer / saradhi
Active Transformation means the no of records u got from
source table is filtred by the transformation and got only
few records may or may not at the target table so this an
active transforamtion. example: if u filtered the data by
agreegate function like sum(sal) here u got only one column
as output so its an active.
Passive means the no of records u got from source table is
equal to the target table records even though the
transforamtion is done
example: sal+comm here u got same no of records as source
after filtering also.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / soujanya
if all source records sends to target or for further
processing using any tranformation then the output is same
as source no. of records then it is passive transformation.
otherwise it is active
source no of records = target no. of records(passive)
source no. of records!=target no. of records(active)
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / v.ramakrishna
In active trnasformation no of records extracted as input
can be vary with no of records come as output. where as in
active transformation no of records extracted as input
cannot vary with no of records comes out as output that
means no filteration according to no of records in passivi
transformation
| Is This Answer Correct ? | 0 Yes | 0 No |
what is distinct
follwing scenario two table using find maximum salary? table a table b 101 xxx 1000 106 6500 103 yyy 5000 108 800 104 din 6000 109 7000 105 dsh 200 110 3000
if i have a delimited file as source so how can we seperate this file into three diff targets?
difference between repository database and repository service?
What is update override?
write sql query following source table jan feb mar apr 100 200 300 400 500 600 700 800 900 100 200 300 i want the output format like month total jan 1500 feb 900 mar 1200 apr 1500
What are the uses of a Parameter file?
Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions
What are mapplets? How is it different from a Reusable Transformation?
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 How to do the above scenario in Informatica.
hi all, Can anyone please tell me the relationship between informatica and business objects
How to display last 5 records in a table ? With out Top key word and doing order by desc Advance thanks
Teradata 
