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
- 7448 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 a node in Informatica?
how to run two workflow(not a sessions) sequentially, what is the process. Plz explain detailed information.
What are the different types of repositories created using informatica?
What if we sort the data in descending order instead of increasing order in sorter t/f and send the data in aggregator t/f is there any performance downfall? Please answer below. thank you.
is there any way to read the ms excel datas directly into informatica?like is there any possibilities to take excel file as target?
How to load last n records of file into target table - informatica
What is meant by pre and post session shell command?
for ex: in source 10 records are there with column sal. use a filter transformation condition as Sal=TRUE and connect to target. what will happen.
following source name gender ramya female ram male deesha female david male kumar male i want the target male female ram ramya david deesha kumar any body give solution above question?
What is informatica?
I have a source either file or db table Eno ename sal dept 101 sri 100 1 102 seeta 200 2 103 lax 300 3 104 ravam 76 1 105 soorp 120 2 Want to run a session 3 times. First time: it should populate dept 1 Second time: dept 2 only Third time: dept 3 only How can we do this?
how to load rows into fact table in data warehouse
Teradata 
