Answer / srinu

Hi, Krishraj,
un-common records mean,,,,(Syntax based,Datatype based,...)
?

Hi, Sharad Sharma
By default it will follow UNION ALL Functionlity.
It will allows Duplicate also.
?

Thanks for Replay!
N.srinu

Answer / priyank

First of all union transformation allows duplicate ddata to
pass through. Now say we have n input groups and there are
m records coming from them. In the output group all the m
records will go through.

For a transformation to be an Active transformation, it has
to satisfy either of the below 3 conditions:

1. no of i/p <> no of o/p
OR
2. row type of the input row changes.
OR
3. Transaction scope of the input rows changes.

For union transformation as discussed above , it satisfies
the 1st and the 2nd condition. But the order in which the
input is passed through the union transformation is not
fixed as in the first record to pass through the
transformation can be from the nth source and the last
record can be from the 1st source. So here the transaction
scope of the input rows changes and hence Union
transformation is an Active transformation.

Answer / hardeep

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. Using the Union transformation to merge data from multiple sources is similar to using the UNION ALL SQL statement to combine the results from two or more SQL statements. Similar to the UNION ALL statement, the Union transformation does not remove duplicate rows.

You can connect heterogeneous sources to a Union transformation. The Union transformation merges sources with matching ports and outputs the data from one output group with the same ports as the input groups.

Answer / ravi

hi all please post relevant answers the question is why
union transformation is active transformation
not the properties of union transformation

Answer / krishraj

It is simple logic, UNION fectches the commmon records
between two tables and it emliminated un-common records. So
it will be Active transformation which means it will change
the number of records.

Any other answers please....

Answer / sharad sharma

The simple ligic of Union is that, It capture all the
unique recorde from bothe the source.
suppose if you have 10 records in table A and 10 records in
table B, in which 3 records are same in both the tables.
Then after using the Union transformation you will get 17
records, as the rescords which are getting duplicated will
not be in the output.

why cant we put a sequence generator or upd strategy transformation before joiner transformation?

2 Answers   Satyam,

wht target override?wht advantages it has compare to target update?

2 Answers   Polaris,

what is rank and dense rank in informatica with any examples and give sql query for this both ranks

4 Answers  

What are the different options used to configure the sequential batches?

2 Answers   Wipro,

Differentiate between a repository server and a powerhouse?

0 Answers  

How can we join the tables if they don't have primary and foreign key relationship and no matching port?

7 Answers  

following scenario empsal table i want who exist one lakshs sal above monthwise? ` empsal empid monthyear sal 1 jan2008 1000 2 march2009 50000 3 april2009 4000 4 feb2009 100000 5 jul2009 600000 6 dec 2008 90000

5 Answers   Wipro,

How will you update the row without using update statergy?

10 Answers   CTS,

Source table ------------- ID NAME --- ------ 101 PANKAJ NULL KUMAR NULL MATHUR 102 JYOTI NULL SAXENA 103 SACHIN NULL TENDULKAR TARGET TABLE ------------- ID NAME --- ------- 101 PANKAJ KUMAR MATHUR 102 JYOTI SAXENA 103 SACHIN TENDULKAR How to do the above scenario in Informatica.

4 Answers   Cap Gemini,

What do you mean by enterprise data warehousing?

0 Answers  

how many repositories can v create in informatica .

3 Answers   Cap Gemini, Tech Mahindra,

hi all hi have flat file like below my requirement is empid,ename,sal,loc 101,vamshi,5000,hyd 101,vamshi,5020,hyd 201,raju,5000,hyd 202,ram,4000,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd i want the o/p like this in one target 201,raju,5000,hyd 202,ram,4000,hyd and in second target 101,vamshi,5000,hyd 101,vamshi,5020,hyd 203,kumar,3500,pune 203,kumar,3500,pune 203,kumar,5000,hyd 203,kumar,6000,hyd

9 Answers   IBM,