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?
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 start a workflow using pmcmd command?
What are the steps involved in the migration from older version to newer version of Informatica Server?
How to create Target definition for flat files?
What is a sorter transformation?
How are indexes created after completing the load process?
What are the differences between a connected lookup and unconnected lookup?
What do you understand by term role-playing dimension?
list out all the transformations which use cache?
what is the Default Source Option For Update Strategy Transformation?
Whats there in global repository
What are the different types of transformation available in informatica.
Can informatica load heterogeneous targets from heterogeneous sources?
hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you
explain one complex mapping with logic? sales project?
How can one identify whether mapping is correct or not without connecting session?