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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to do unit testing in informatica?

1228


what is index?how it can work in informatica

2083


How can we update a record in the target table without using update strategy?

1201


How do you convert single row from source into three rows into target?

1211


How can you validate all mappings in the repository simultaneously?

1423


How many dimensions are there in informatica?

1134


list out all the transformations which use cache?

1239


Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance

2054


Which is the t/r that builts only single cache memory?

1237


How to update a particular record in target with out running whole workflow?

1627


What is update strategy transform?

1160


design of staging area?

2075


Have you worked with/created Parameter file

1711


Give one example for each of conditional aggregation, non-aggregate expression, and nested aggregation?

1320


What are the differences between joiner transformation and source qualifier transformation?

1235