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
Global and Local shortcuts. Advantages.
How can we use mapping variables in informatica? Where do we use them?
What is rank transformation?
What is a repository? And how to add it in an informatica client?
What is the cumulative sum and moving sum?
How can we delete duplicate rows from flat files?
What is the function of aggregator transformation?
What is meant by a domain?
What happens to map if we alter the datatypes between source and its corresponding source qualifier?
How to generate or load values in to the target table based on a column value using informatica etl tool.
I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?
What are the databases that informatica can connect to windows?
What is lookup change?
how to load rows into fact table in data warehouse
What do you mean by channel change?