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.

If informatica has its scheduler why using third party scheduler?

0 Answers  

in source one table is there. id value --- ------ 1 a 2 b 3 c 1 d 2 e 1 f in target i want id value ---- ------ 1 a,d,f 2 b,e 3 f How to implement it in informatica without using normalizer transformation?

2 Answers   IBM,

my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?

10 Answers   Cap Gemini, Wipro,

What is the commit type if you have a transaction control transformation in the mapping?

0 Answers   Informatica,

Have you worked with/created Parameter file

0 Answers  

hi talents, how do u get sequece numbers with oracle sequence generator function in informatica.... i dont need to use sequence generator transformation..... how do u achieve this???

3 Answers   HP,

In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?

6 Answers  

while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile

2 Answers   Amdocs,

without update strategy how to insert &update?

1 Answers   DELL,

What do you mean by channel change?

0 Answers  

WAT IS THE MEANING OF UPGRADTION OF REPOSITORY?

1 Answers   Wipro,

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

2 Answers   iGate,