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


How union transformation is active ?

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

Is it possible to create multiple domains on a single Informatica server?

0 Answers  


to improve the performance of aggregator we use sorted input option and use sorter t/r befor aggregator. But here we are increasing one more cache in our mapping i.e; sorter. So how can u convince that you are increasing the performance.?

3 Answers   IBM,


How to handle changing source file counts in a mapping?

3 Answers   Deloitte, TCS,


how to join the 2 different table with different columns in informatica?

5 Answers   Accenture,


Please explain in detail with example about 1.Confirmed Dimension. 2.Junk Dimension. 3.Degenerated Dimension. 4.Slowly changing Dimensions

3 Answers   Infotech,


Can we schedule a workflow(not a session) to run after completition of another workflow? Can we make a workflow depend on completition of another one?

2 Answers   GE,


What are the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?

0 Answers  


Can I create one wrkflw which will run different wrkflws on schedule time?

3 Answers  


What is difference macros and prompts?

2 Answers  


How can a Lookup with Dynamic Cache be replaced in a mapping? Explain.

2 Answers   TCS,


What are the different caches used in informatica?

3 Answers   UST,


when we dont use aggregator in mapping ?

2 Answers   CSC,


Categories