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

Answer / nagaraju bhatraju

joiner:
joiner doesn't require marching ports to join ,
both shoud be from heterogenious sources.


union:
union requires two flows with same no of columns and both
columns of the two flows orders should be same to produce
the combined flow .

Answer / dillip

Joiner transformation is horizental transformation
but union is is vertical trans formation

Answer / chandrp

At the maximum a join trasformation can join only 2 tables.
but union transformation will join more than two tables at
a time.

Answer / ashu alle

joiner transformation supports homogenious and
heterogenious data..

union transformation supports only heterogenious data

Answer / singh.

hello Chandrp . ur answer is wrong.
in my view join T/r can join more than 2 tables
try with 3 flat files. then u will get the result.

why we use informatica in our project?

2 Answers   TCS,

What is a pre-defined event and user-defined event?

0 Answers  

a soure table has 100 records how to load into 3 target tables in a cumulative order source target1 target2 target3 --------- ------------------------------------- 1-100 1 2 3 4 5 6 - - - 98 99 100

2 Answers   Cap Gemini,

What are the tasks that source qualifier perform?

0 Answers   Informatica,

COL1,COL2 ABC,1 XYZ,2 HERE IN COL2 VALUES 1,2 NOT STSANDARD(IE MEANS NOT FIXED VALUES LIKE OTHER SOME VALUES LIKE 10,20) O/P IS COL1,COL2 ABC,2 XYZ,1

0 Answers  

i have one senario i have table with 2columns one for primary key another is a constant value(zero). i have to lookup the table and get the maximum primary key here i don't have any common column between source and lookup table(wt table i explained above)... table is (i am assuming he didn't give the table) column1 column2 5 0 2 0 8 0 6 0 3 0 12 0 7 0

2 Answers   TCS,

if soource is having 10 records how will u insert 20 records to target

6 Answers   HCL,

Do you have to change the reject file b4 using reject loader utility.

1 Answers  

what are 3 tech challenges/ common issues you face?

0 Answers   TCS,

What is the surrogate key?

0 Answers  

how will compare two mappings in two different repository?

2 Answers   Real Time, TCS,

what is unique constraint error ?

2 Answers   TCS,