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
- 9381 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
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
What is decode in informatica?
Where are the source flat files kept before running the session?
explain abt ur project architecture?
What is difference between a gateway node and worker node?
permutations of mapplet
i had a source containing business,sales,details column and i have to load it to a target but i have some bad records in it , but i have to load 70% of business records and 50% of sales and 95% of details records excluding bad records to achieve this what should be done and what all logic and tx should be used can anyone help? thanks in advance
What is a grid in Informatica?
how will u take the data from clint server and next what u do in datamodeling what u will u do in staging area what u will u do next what u are doing please give the step by step by process
Explain lookup transformation source types in informatica
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What is the function of look up transformation?
What are pre and post-session shell commands?
Explain the different kinds of facts.
What is dynamic cache?
