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
- 7676 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 the advantage of informatica?
complex mapping ur project u r invlve can u explain and give real time example give me ?
Why filter transformation is an active one?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
How to elaborate tracing level?
How to update a particular record in target with out running whole workflow?
Explain the informatica workflow?
What are the tuning techniques you applied during your last project
Different sorts of metadata that stores in the storage facility?
How to open an older version of an object in the workspace?
Under what conditions selecting sorted input in aggregator will still not boost session performance?
In informatics server which files are created during the session rums?
How to use procedural logic inside infromatica? If yes how, if now how can we use external procedural logic in informatica?
What is the format of informatica objects in a repository?
How to load a Dimension ? and how to load a fact table?
