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?

Answers were Sorted based on User's Feedback



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

Answer / raj

Join Transformation combines data record horizontally based on
join condition.
And combine data from two different sources having different metadata.
Join transformation supports heterogeneous, homogeneous data source.

Union Transformation combines data record vertically from multiple sources, having same metadata.
Union transformation also support heterogeneous data source.
Union transformation functions as UNION ALL set operator

Is This Answer Correct ?    30 Yes 2 No

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

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

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

Answer / ash.gadgi

Joiner Transformation merge horizontally

Union Transformation merge vertically

Is This Answer Correct ?    13 Yes 9 No

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

Answer / yaseen

we can create multiple input groups,but only one
out put group
Union Transformation combines data record vertically from multiple sources, having same metadata.
The structure and Data types should be same while using Union transformation
Join Transformation combines data record horizontally based on
join condition.

Is This Answer Correct ?    1 Yes 0 No

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

Answer / swapna

A joiner Transformation is used to join data from
hertogenous database ie (Sql database and flat file )
where has Union transformation is used to join data from
the same relational sources.....(oracle table and another
Oracle table )

Is This Answer Correct ?    10 Yes 32 No

Post New Answer

More Informatica Interview Questions

What is the capacity of power cube?

1 Answers  


In Flat file, I need Header, Footer and No of rows in Last column. How will u achieve in Mapping Level(With out using Session Level Property)?

1 Answers   iNautix,


My Source qualifier has empno, sal. Now my mapping is like SQ(EMPNO)->AGGR->EXP->TARGET SAL ------------>TARGET ? Is this mapping valid or any issues are there if we design like this?

3 Answers   Span Systems,


lookup transformation with screenshots

0 Answers   TCS,


in which situations we go for pesistent cache in lookup and which situations go for shared lookup cache?

2 Answers   Cap Gemini,


If u select groupby port in aggregator what is output and dont select groupby option what is output

2 Answers  


You have defined the following: - Commit Type = 'Target' - Commit Interval = 10000 - writer buffer block can hold multiple 7,500 rows - you are loading 40,000 records into the target After how many records will the Informatica Server issue commit commands? a)7500, 15000, 22500, 30000, 40000 b)15000, 22500, 30000, 37500, 40000 c)15000, 22500, 30000, 40000 d)15000, 30000, 40000

7 Answers   Deloitte,


how to convert the .doc docs into .txt format using informatica

4 Answers  


Why use shortcuts(Instead of making copies).

1 Answers  


In target table how to display the system time

1 Answers  


Explain what are the different types of transformation available in informatica.

0 Answers  


How to do Integration testing in Informatica?

5 Answers   Intelligroup,


Categories