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
- 7590 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What is a filter transformation?
Why is sorter an active transformation?
What is enterprise data warehousing?
What are the basic requirements to join two sources in a source qualifier transformation using default join?
What is expression transformation?
What are the new features of informatica 9.x in developer level?
Explain Dataware house architecture .how data flow from intial to end?
Clarify the aggregator change?
How to go to the older version for a mapping?
What is the need of an ETL tool?
Explain in detail about scd type 1 through mapping.
Explain how to import oracle sequence into informatica?
Explian the Process of deployment groups in informatica
How can you define user defied event?
What is the commit type if you have a transaction control transformation in the mapping?
