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?

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


Please Help Members By Posting Answers For Below Questions

How to start a workflow using pmcmd command?

1306


What are the steps involved in the migration from older version to newer version of Informatica Server?

2151


How to create Target definition for flat files?

1281


What is a sorter transformation?

1155


How are indexes created after completing the load process?

1718


What are the differences between a connected lookup and unconnected lookup?

1123


What do you understand by term role-playing dimension?

1116


list out all the transformations which use cache?

1239


what is the Default Source Option For Update Strategy Transformation?

1286


Whats there in global repository

1737


What are the different types of transformation available in informatica.

1144


Can informatica load heterogeneous targets from heterogeneous sources?

1232


hi friends ... i have insurance project(informatica),can you please tell me how many table and mappings we need to use?and explain me.. thank you

9897


explain one complex mapping with logic? sales project?

6730


How can one identify whether mapping is correct or not without connecting session?

1495