Interested to Buy Any Domain ? << Click Here >> for more details...
I am having two tables,say table1 having cols
Empid,firstname,lastname,middlename and table2 having
Empid,firstname,lastname can i union them using Union t/f?
- 6 Answers
- 11335 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / pavana
Yes , we can created 2 input groups with 4 columns . For 1st
input group pass all columns from table 1 ,for 2nd input
group pass all 3 columns from table 2, 4th column from in
2nd group remain unconnected.
Session executes successfully. output will be the union of 2
tables. The 4th column from 2nd table will be populated as
null in output.
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
generate date / time dimension in informatica
What are the popular informatica products?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
How to configure mapping in informatica?
What is meant by pre and post session shell command?
Why sorter is an active transformation?
What is workflow? What are the components of workflow manager?
How many number of sessions can one group in batches?
What is sq transformation?
pmscmd startworkflow -sv
How we can create indexes after completing the loan process?
What is meant by target load plan?
Define Pmrep command?
is it possible to index the data in cache of lkp transformation ?
How to join three sources using joiner? Explain though mapping flow.
