why union is active transformation?
Answers were Sorted based on User's Feedback
Answer / shobhan
if input number of rows are not equal to output number of rows, that would be Active transformation. In Union Transformation, input will more and output will be less. SO, this is a Active Transformation.
| Is This Answer Correct ? | 2 Yes | 4 No |
Answer / amedela chandra sekhar
Union it support only same metadata in both the tables.
it will execute same metadata.
it means reject the unmatched data.
so reject some records.
so it changes the no of records
| Is This Answer Correct ? | 2 Yes | 7 No |
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
How to list Top 10 salary, without using Rank Transmission?
can any one give some examples for pre sql and post sql(Except dropping and creating index).
What is meant by lookup transformation? Explain the types of lookup transformation?
What is parameter file?
how to return multiple columes through through un-connect lookup?
What are the types of maping in Getting Started Wizard?
What are the different threads in DTM process?
What are the new features in Informatica 5.0?
Two workflows are running at same time first workflow is succeeded but second workflow is failed but there is no dependencies?
What is Session and Batches?
What are the mapping paramaters and mapping variables?