why union transformation is active transformation?
Answer Posted / venkateshmalneni
If the source1 has 10 records and the it contains 3 records
and the same 3 records are in the second source,the second
source contains 10 records if we want to join them using union
t/r then the output is 17 records instead of 20 records.
thats why we say that UNION T/R is active t/r
| Is This Answer Correct ? | 3 Yes | 32 No |
Post New Answer View All Answers
explain about unit testing? in real time?
Explain pushdown optimization $pushdownconfig parameter - informatica
How to convert a row into column and a column into rows? Name all DTM threads. What all threads stop when we issue STOP or ABORT? How to pass the value of a data(variable kind of) from one session ( generated in mapping) to another session in the same workflow... What are the tyoes of partitioning you know and how to apply them in real time ... Can partitioning be applied to expression transformation and how
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
Can we override a native sql query within informatica?
Differences between version 7.x and 8.x.
Explain the different kinds of facts.
What are the transformations that are not supported in mapplet?
What are mapplets?
What is sorter transformation?
What is substr in informatica?
What is meant by active and passive transformation?
difference between repository database and repository service?
What are the new features of informatica 9.x in developer level?
what is the difference between informatica6.1 and infomatica7.1