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
- 11341 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / ravikumar2614
Yes we can.
create one more colomn in table-2 with same data type and assaign null values to that colom, then we can union two tables.
please correct if am wrong.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How to improve the performance of a session using sorter transformation?
What is Index Caches size?
Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?
How do you use reject loader.
Can u generate reports in Informatica?
how tokens will generate?
What is the main purpose of Unconnected lookup other than updating slowly changing dimensions? or In which case u use Unconnected lookup?
in reporting we add some new objects,how we get the count of the newly added objects to the report
What do you mean by blocking transformation?
What is data caches/ index caches?
What is the Rank index port in Rank transformation?
Can we get 1st record through Informatica(without sequence number).
What is a passive transformation?
What are the conditions needed to improve the performance of informatica aggregator transformation?
What is the fact table?
