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 polling?
What is an MDDB? What is the difference between MDDBs and RDBMSs?
what is difference between mapping and mapplet ?
what is the look up transformation?
what r the values tht r passed between informatics server and stored procedure?
while for 100 records in source table loaded sucessfully in trgt table . assume ,session will take 10min or 5 min to successfully succeeded. then 100 million records r there in source how much time will take by session to succeeded. there no fail ok.trgt table will load 100 million records with out any errors . don't tell perfect time . assume your self how much time to succeeded?
What is confirmed dimension?
What are 2 modes of data movement in Informatica Server?
what is the monster dimension plz give me one example
What are differences between Informatica 7.1 and 6.1
hi all my source looking like below column1 column2 101,102,103 abc,def,ghi 1001,1002,1003 a,b,c i want my target is column1 column1 101 abc 102 def 103 ghi 1001 a 1002 b 1003 c any one can you help
If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?