Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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?

Answers were Sorted based on User's Feedback



I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 havin..

Answer / 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

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 havin..

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

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 havin..

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

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 havin..

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

I am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 havin..

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 am having two tables,say table1 having cols Empid,firstname,lastname,middlename and table2 havin..

Answer / maheedhar

I said yes,correct me if am wrong

Is This Answer Correct ?    9 Yes 10 No

Post New Answer

More Informatica Interview Questions

If in a workflow i have n number of sessions and each session is configured with different different stop on errors (say 5,8,10 etc respectively).How can make all this same for all the sessions with out actualy touching each and evry session ?

1 Answers   Wipro,


In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 Answers  


What are the types of lookup?

3 Answers   Wipro,


SOURCE DATA IS DISPLAY IN THIS FORMATE IN TARGET . WHAT BUSINESS LOGIC WE CAN APPLY. source table target table ------------ ------------ c1 c2 c3 c1 c2 c3 -- -- -- -- -- -- 1 A J 1 2 B K 2 A 3 C L 3 B J 4 D M 4 C K 5 E N 5 E L F M N

0 Answers   Infotech,


How many ways are there to create ports?

0 Answers   Informatica,


Where do we use mapping variables in informatica?

0 Answers  


Could any one to tell Fact table Partitioning?

2 Answers  


What are the methods for creating reusable transforamtions?

2 Answers  


Suppose i have 10000 records.First time i have to load 1 to 1000 records and second run i have load 1000 to 2000 records and third load i have to load 2000 to 3000 rows .How will achieve

15 Answers   TCS,


What is the diff. b/w informatica versions 8.1.1 and 8.6.1?

4 Answers   IBM, Wipro,


what is junk dimension

4 Answers   Cap Gemini,


What are different types of transformations available in informatica?

0 Answers  


Categories