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
- 11072 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
On which transformations you created partitions in your project?
How does the aggregator transformation handle null values?
What is sorter transformation?
Explian the Process of deployment groups in informatica
What is a transaction control transformation?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
Scheduling properties,whats the default (sequential)
What is a code page?
if i hv 6 table as source table but can i make 12 as a dim table and 6 as fact table belongs to that src table.
What do you understand by SOA of Informatica?
What do think which one is the better joiner or look up?
What is meant by target load plan?
What if the source is a flat-file?
Performance tuning( what you did in performance tuning)
What is the meaning of up gradation of repository?
