I still need further explanation about the difference
between active and passive transformation with some
examples.Thank You
- 5 Answers
- 5902 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 |
two tables from two different databases r there . both having same structure but different data . how to compare these two tables ?
lookup is passive y can't it be active? let us say i have some records in my source like 101,rohit,1000 101,rohit,1000 102,kumar,2000 like wise now as it is having multiple matches i return only first,last value it can't return bouth the values that means lookup is acting as select distinct right by default what means it is active?
write sql query following table pname description lux soap sunsilk shampoo lux shampoo sunsilk soap clouseup soap closeup paste i want the output like pname description lux soap sunsilk shampoo lux soap sunsilk shampoo closeup paste closeup paste
How do you change parameter when you move it from development to production.
How many input parameters can exist in an unconnected lookup?
How to elaborate powercenter integration service?
I cleared Informatica certification Designer. if anybody need dumps, can contact at mukesh1009@gmail.com
119 Answers Accenture, Gcs, TCS,
What is IQD file?
I have worked on Informatica 7.1.1. I want to know the answer for the below question. Target is not created initially.Then how to take the DDL script from the source and run the Mapping by creating the Target dynamically?Is it possible by SQL Transformation?
suppose a session is failed after a transformation , from where that session will run again , i.e . from beginning or from that transformation ?
Is snow flake or star schema used? If star schema means why?
what r the values tht r passed between informatics server and stored procedure?
Teradata 
