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?



explain abt union t/r?..

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

More Informatica Interview Questions

What is metadata reporter?

1 Answers   Informatica,


What is a parameter When and where do you them when does the value will be created

0 Answers  


In aggregator transformation, I sort the data before aggregator and select sorted port but still I’m getting an error. What is that error?

2 Answers  


what is meant by data driven.. in which scenario we use that..?

2 Answers   IBM,


What is the function of aggregator transformation?

0 Answers  


Source Qualifier is an active t/r but there is no change of row count then y should we called it active t/r & Router , sorter some times no change in row count then Y we called its active t/r?

2 Answers  


i have 2 flat files one table contains duplicates another one no duplicates.... so i need like this i don't want duplicates...pl's give me ans...

4 Answers   Keane India Ltd,


Hi I'm new in Informatica. Can you show me a mapping sample on how to piviot the records? Thanks Robin

1 Answers  


how to get the data from the client machine and how to get server location data to client loction can any one explain bit deep please..!

3 Answers   TCS,


my source like dis 10,asd,2000 10,asd,2000 10,asd,2000 20,dsf,3000 20,dsf,3000 20,dsf,3000 like dis and my requirement is first record is inserted into first target and duplicates of first record is inserted into second target ...like dis way ...? how to achieve dis?

4 Answers   Mind Tree, Polaris,


can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com

0 Answers   IBM,


Hi all, iam new to informatica, can anyone tell me what is unit testing & how it is done? thank u

3 Answers  


Categories