Question { Accenture, 9389 }
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
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