Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Informatica
  2. Suggest New Category

How union transformation is active ?

Question Posted / cmanojkumar

Answers were Sorted based on User's Feedback



How union transformation is active ?..

Answer / kish

union t/r means multi input source merged into single output
group.and also union t/r work as union all in oracle. and it
support duplicate data but union t/r having property is
their "make it active" enable them that's why it does not
accept duplicate record.this is the process

Is This Answer Correct ?    2 Yes 1 No

How union transformation is active ?..

Answer / priyank

As per the definition of the Active transformation, the no
of rows going in should be equal to the no of rows going
out.Besides that the row id of the input rows should be the
same the row id of the out going rows.

Henceforth, union transformation is true for the first
condition where the no of rows entering is same as the no
of rows going out as Union transformation treats rows for
UNION ALL condition. But in the second condition i.e. Row
id,there is no control on the rows which enter the Union
transformation from different sources so the Row id can
change.

Is This Answer Correct ?    3 Yes 4 No

Post New Answer

More Informatica Interview Questions

IF Sorce table contains CLOB as its one data type then i get error at the target table. How can this be resolve?

2 Answers  

What are slowly changing dimensions?

5 Answers   Informatica, Verinon Technology Solutions,

Consider two cases: (1) Power Center Server and Client on the same machine (2) Power Center Sever and Client on the different machines what is the basic difference in these two setups and which is recommended?

2 Answers  

What are the ETL tools available in DWH?

6 Answers   Mphasis,

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

2 Answers   IBM,

how can u generate sequence of values in which target has more than 2billion of records.(but with sequence generator u can generate upto 2 biliion only)

6 Answers   Accenture,

how can we check whether a particular cache is static or dynamic?

1 Answers   InfoCepts, TCS,

How will you display 10-15 letters from a name? (for ex: name="sivasubram'aniam'ramakrishnan". o/p wanted="aniam")

4 Answers  

What is confirmed dimension?

3 Answers  

What is workflow monitor?

0 Answers  

Mention a few design and development best practices for informatica?

0 Answers  

Define informatica repository?

2 Answers   Wipro,

For more Informatica Interview Questions Click Here
Categories