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

What is the main difference between a Joiner Transformation
and Union Transformation?

Answer Posted / medatati satya teja ravi kiran

UNION:1)we can create multiple input groups,but only one
out put group
2)we can connect heterogeneous sources to a union
transformation
3)The union tf does not remove duplicate rows.To remove
duplicte rows, we must add another tf such as router or
filter tf


JOIN:1)Used to join source data from two related
hetorogeneous sources residing in different locations or we
can join data from the same source
2)The joiner tf remove duplicate rows...

Is This Answer Correct ?    8 Yes 3 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What does cheating measurement mean?

1010


What is an active transformation?

1055


What is an expression transformation?

983


design of staging area?

1986


Which are the different editions of informatica powercenter that are available?

994


What are the reusable transformations?

1120


Explain how to import oracle sequence into informatica?

972


can u give example for factless fact table

6499


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

9769


How might you approve all mappings in the archive all the while?

977


How do we call shell scripts from informatica?

1041


What is status code in informatica?

978


What is the procedure for creating independent data marts from informatica 7.1?

1029


What are the different ways to implement parallel processing in informatica?

1366


State the differences between sql override and lookup override?

1144