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

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

what is diffrence b/w joner and union transfermation

Question Posted / murali

Answer Posted / murali

JOINER
TRANSFORMATION:

to join source data from two related heterogeneous sources
residing in different locations or file systems. Or, you
can join data from the same source.


If you need to join more than two sources, you can add more
Joiner transformations to the
mapping.



You cannot use a Joiner transformation in the following
situations:
Either input pipeline contains an Update Strategy
transformation.
You connect a Sequence Generator transformation directly
before the Joiner transformation.

UNION
TRANSFORMATION:




The Union transformation is a multiple input group
transformation that you can use to merge data from multiple
pipelines or pipeline branches into one pipeline branch.

The Union transformation merges sources with matching ports
and outputs the data from one output group with the same
ports as the input groups.
Similar to the UNION ALL statement, the Union
transformation does not remove duplicate rows.

Is This Answer Correct ?    16 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the meaning of up gradation of repository?

1893

What is native users?

1097

differences between service based and product based?

1965

Explian the Process of deployment groups in informatica

987

Can we use the mapping parameters or variables created in one mapping into any other reusable transformation?

1216

My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?

1873

Mention few advantages of router transformation over filter transformation.

982

What are the main issues while working with flat files as source and as targets ?

1091

Hi, I am planning to take Infa Certification exam but am unable to find its dumps anywhere on web. If anybody has it, plz share them with me. jkinfo22@gmail.com Thanks in advance

1994

What is workflow? What are the components of the workflow manager?

1059

Where is metadata stored?

1038

What are the different versions of informatica?

1180

What are the restrictions of union transformation?

976

Briefly define a session task?

1048

What are the differences between oltp and olap?

918