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
- 11332 Views
- Accenture, I also Faced
- E-Mail Answers
Answer Posted / sreenu
It is not possible to put both in Union directly,
The group coming to Union must have same number of columns
and its data type must be compatible.
In this case first table has 4 columns and the second table
has 3 only.
alternatively you can follow the below logic to pass to
union transformation
Because the 2nd table has only 3 columns, create dummy
column for the 2nd flow and pass null in that port, so that
you can connect them to Union
| Is This Answer Correct ? | 30 Yes | 4 No |
Post New Answer View All Answers
What is standalone command task?
What is mapping debugger?
Target increases every day even though no new record was inserted
How to load data in informatica ?
What do think which one is the better joiner or look up?
What is update strategy transform?
Is it possible to revert a global repository to local one and why?
What are the different types of transformation available in informatica.
What is rank transform?
What all join we can perform in LOOKUP transformation?
what is the size of your data warehousing?
How you prepared reports for OLAP?
Is stop and abort are same in informatica?
Workflow is long running due to long running sql query so when we refer the query plan it tells the issue is due to partition of the db table. How to handle this?
Where are the source flat files kept before running the session?
