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.

What is up date strategy and what are the options for update strategy?

2 Answers  

what is diff between IN and EXIT commands

1 Answers   HCL, Schneider,

why we need informatica

2 Answers   HCL,

Converting Rows to columns I have Relational source like his. JAN FEB MAR APR 100 200 300 400 500 600 700 800 900 100 200 300 I need to convert these rows into columns to the targe. MONTH TOTAL JAN 1500 FEB 900 MAR 1200 APR 1500 Please experts help me

5 Answers   HP,

What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks

2 Answers   IBM,

how we do performence tuning in informatica

3 Answers  

What is joiner cache?

2 Answers   TCS,

can we see default group,when we use router?if yes how?

2 Answers   L&T,

If my source is having 30 million records, so obviously the cache could not be allocated with sufficient memory. What needs to be done in this case?

2 Answers   TCS,

when load type is selected as bulk or normal in session level ?let me know the internal process and give me an example?

3 Answers  

yesterday my session run ten min.today its run 30min, wt is the reason? if any issues how to solve that?

2 Answers   iGate,

I have a text file name x With a text message. Word informatica Is repeated for n number of times. How to count the number of occurrence Of word informatica Of word informatic in this file x.

1 Answers   Wipro,