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 |
How to create a non-reusable instance of reusable transformations?
1.what is SDLC of a project,explain in detail? 2.what are dimensions,facts?what is confirmed dimensions? 3.what is the need of OLTP? when we have datawarehousing?
I Have 100 Records in a relational tble and i want to load the record in 3 targets , first records goes to target 1 and second to target 2 and third to target 3 and so on ,what are the tx used in this and what are the logics ,can any one help me ?? Thanks in Advance
What is the difference between OLTP and ODS?
What is a passive transformation?
Tell me about your experience in informatica? what is best mark you can give yourself? How to answer this question?
What is joiner change?
Please tell me which institute is the best to study Informatica and asp.net in chennai Also please send me the latest interview questions in asp.net,c# and sql server to my id ramtryin@gmail.com
when do we use static cache and when do we use dynamic cache in lookup transformation? with example.
Describe the scenarios where we go for joiner transformation instead of source qualifier transformation?
what are 3 tech challenges/ common issues you face?
What is the filename which you need to configure in UNIX while installing infromatica?