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

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

Answer / ash.gadgi

Joiner Transformation merge horizontally

Union Transformation merge vertically

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.

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 )

There are 3 groups in router transformation in which there are no conditions mentioned, so what happens if I connect these groups to the 3 targets? How many records gets into each target.(suppose if we are getting 10 records from the source)

4 Answers  

How to open an older version of an object in the workspace?

0 Answers  

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,

How to use pmcmd utility command?

0 Answers  

what is persistant cache in which situation we will use persistantcache

1 Answers   HCL,

How could we generate the sequence of key values without using sequence generator transformation in the target ??

12 Answers   TCS, Tech Mahindra,

Is there any way to read the ms excel datas directly into informatica?

0 Answers  

my source is like this id,name sal 10 abc 1000,10 pqr 2000, 10 xyz 3000 ,10 jkl 4000 and my requirement is like this 10 abc,pqr,xyz,jkl 2000 .... i have try for this by using expression transformatin its ok of the concatenation of second column but the thing is that on third column if u group by using agg t/r the last value will com i.e 4000 but i asked by a interviewer that i dont want the first or last column i want the middle column i.e 2000 .plz reply for the same

2 Answers   KPIT,

What are the two modes of datamovement in informatica sever?

2 Answers  

If we can implement SCD TYPE 1 AND 2 IN A SINGLE MAPPING.. CAN WE SEE THE RESULT IN A SINGLE OUTPUT? I MEAN I WANT THE RELSULT OF BOTH SCD 1 AND 2 TO BE SEEN IN A SINGLE RUN?

1 Answers   TCS,

I have table name in that I have Rajesh Reshika Priya I want the result Like only Starting with R Rajesh Reshika Can someone help me to get these results and How?

3 Answers  

i have two coloumn emp_no sal 1 3000 2 3000 3 3000 4 4000 5 5000 6 2700 7 4500 i just need output by removing duplicate.my answer should be emp_no sal 1 3000 2 4000 3 5000 and so on.please tel me the transformation to use and if variable is used in expression then how can i give variable expression

3 Answers