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
- 7594 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Explain the features of connected and unconnected lookup.
What is a pre-defined event and user-defined event?
Explain joiner transformation in informatica
hi,this is satheesh working as pl/sql resource in MNC.i just wanna switch to informatica.Could you please let me know what is the best way to learn informatica.what are the best coaching centres available in chennai?Is there any coaching centre will give me a real time experience? informatica
Suppose we have a source qualifier transformation that populates two target tables. How do you ensure tgt2 is loaded after tgt1?
In informatics server which files are created during the session rums?
What is the format of informatica objects in a repository? What are the databases that informatica can connect to windows?
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
I have done MBA in 2008. i got job as business analyst in 2008 january through consultany. but after 3 months they are giving training Informatica developer. now iam continuing this job. my question is when iam going to interview HR people ask me many times like this " YOU ARE MBA GRADUATE. HOW YOU ARE SELECT THIS POSTION. IAM EXPLAINING WHAT I HAVE MENTION ABOVE". PLEASE TELL HOW IAM TELLING THIS QUESTION ANSWER.
how lookup transformation is made active in new versions... When to use connected and when to use unconnected lookup and why? which is good for session performance. How to make lookup persistent and how to remove stale data from that lookup. how commit works - when we stop or abort data. Explain in both cases. What is factless fact table and have you ever used it in real time scenarios.
Explian the Process of deployment groups in informatica
How many input parameters can exist in an unconnected lookup?
What is confirmed fact in dataware housing?
What is lookup transformation?
