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
- 9795 Views
- Accenture, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
Answer / ganithi anil
for union t/f tables structures should be same, i mean
columns and data types should besame then only you use
union t/f
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / pavana
Yes , we can created 2 input groups with 4 columns . For 1st
input group pass all columns from table 1 ,for 2nd input
group pass all 3 columns from table 2, 4th column from in
2nd group remain unconnected.
Session executes successfully. output will be the union of 2
tables. The 4th column from 2nd table will be populated as
null in output.
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / 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 |
Answer / sudheer
No need to create any dummy column(table-2) and make it as null...
Just create 2 groups as u have 2 tables and create 4 group ports like below Empid,firstname,lastname,middlename.
-Drag respective columns from src to union.
-Don't make any link for middle name from table as we don't have any column but drag all columns from table 2 and save the mapping and run the session.....This will work as i have tested.Thanks......
| Is This Answer Correct ? | 0 Yes | 0 No |
I have 1 crore record in my table and I have to load 25 L in 1st target,25L in 2nd target and 25L in 3rd target? I am new to Informatica,can anybody suggest me the idea?
What does role playing dimension mean?
In which circumstances that informatica server creates Reject files?
What are the issues that you have faced while moving your project from the Test Environment to the Production Environment? Please explain in depth thanks in advance
Why can't we use few transformations in mapplet ? like xml and target defintions, seq etc ?
Is it possible to use a client with different version than that of its Informatica server?
My source contains 10 records with 5 columns.What happens if I select group by all columns in Aggregator T/R?
what is the need of session partitioning... how it is useful in real time
what is mapping performence?
how the data will be loaded while desiging the schema?which one first (for e.g.-dimesions and facts)
What is informatica worklet?
Plz can any one say me how to get the informatica certification materials and dumps
Teradata 
