Interested to Buy Any Domain ? << Click Here >> for more details...
I still need further explanation about the difference
between active and passive transformation with some
examples.Thank You
- 5 Answers
- 7840 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 |
I have some rows in source.I have to map half rows to one target and half rows to another target.i.e you wont know how many records in source.?Implement a mapping?
if we have certain records,if i need to get 5 th rec for the first time to the target,when i run it for next time,i need to get 6th rec...like that it should process.what wil be the procedure to achieve it??
What are the designer tools for creating transformations?
how to work with mapplet designer in informatica?
If a workflow stops or fails after loading 10k records ? How can you recover it and If there is no order while reading data from source ?
What do you mean by enterprise data warehousing?
Separate from a database, an information bazaar, and an information stockroom?
What do mean by local and global repository?
my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same
If i done any modifications for my table in back end does it reflect in informatca warehouse or maping desginer or source analyzer?
How to differentiate between the active and passive transformations?
Why you use repository connectivity?
Teradata 
