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

explain abt union t/r?

Answer Posted / suraj kedia

A union transformation is a multiple input group
transformation,which is used to merge the data from multiple
sources similar to UNION All SQL statements to combine the
results from 2 or more sql statements.
Similar to UNION All statement, the union transformation
doesn't remove duplicate rows.

It is an active transformation.

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

I have 100 records in source table, but I want to load 1, 5,10,15,20…..100 into target table. How can I do this? Explain in detailed mapping flow.

1790


Hi friends I want to know about what r the dimensions in the banking porjects and genarally how many tables r in project ?

1951


How to delete duplicate row using informatica?

1084


how can we find the bottle neck in SQL Query in SOURCE QUALIFIER, and how can we tune it..?

7172


What is sequence generator transformation in informatica?

1118


What will be the approach?

1035


How do you load more than 1 max sal in each department through informatica or write sql query in oracle?

1641


What is option by which we can run all the sessions in a batch simultaneously?

1185


How to load data in informatica ?

1065


What is native users?

1216


What is dimensional table? Explain the different dimensions.

1241


What do you mean by worklet?

1112


Is it possible to define a single node as a Gateway node as well as worker node?

1175


How can we create index after completion of load process?

1162


 Informatica Checkpoints

3373