why union is active transformation?

Question Posted / ramesh.chowdary8

4 Answers
8018 Views
IBM, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

why union is active transformation?..

Answer / rakesh

since Union Transformation is derived from CUSTOM Transformation which is active.

Is This Answer Correct ?

6 Yes

0 No

why union is active transformation?..

Answer / shobhan

if input number of rows are not equal to output number of rows, that would be Active transformation. In Union Transformation, input will more and output will be less. SO, this is a Active Transformation.

Is This Answer Correct ?

2 Yes

4 No

why union is active transformation?..

Answer / swathi

bcz union supports vertical merging

Is This Answer Correct ?

1 Yes

4 No

why union is active transformation?..

Answer / amedela chandra sekhar

Union it support only same metadata in both the tables.
it will execute same metadata.
it means reject the unmatched data.
so reject some records.
so it changes the no of records

Is This Answer Correct ?

2 Yes

7 No

Post New Answer

More Informatica Interview Questions

Hi i am new to Informatica. I have few question's in Informatica. Can any one respond, it will be appricaited. Q.Is Flat File Contains the Dynamic Cache?

6 Answers

Hi frndz, "while i am going to run the infotmatica power designer,he ask the id and password ",then i enterd the id and passwd , at that time i got the error as " failed to connect repository " ?

3 Answers

Could anyone please mail me a copy of Informatica Certification Exam dumps to sandeep.nakka@gmail.com it would be appreciated if any one could help me out.

0 Answers

Suppose we have a (assume relational) source table Product_Id Month Sales 1 Jan x 1 Feb x . . . . . . 1 Dec x 2 Jan x 2 Feb x . . . . . . 2 Dec x 3 Jan x 3 Feb x . . . . . . 3 Dec x . . . . . . and so on. Assume that there could be any number of product keys and for each product key the sales figures (denoted by 'x' are stored for each of the 12 months from Jan to Dec). So we want the result in the target table in the following form. Product_id Jan Feb March.. Dec 1 x x x x 2 x x x x 3 x x x x . . So how will you design the ETL mapping for this case , explain in temrs of transformations.

5 Answers Accenture, VAMA,

What are the steps involved in the migration from older version to newer version of Informatica Server?

0 Answers

What is the difference between informatica 8.x and 9.x

1 Answers Wipro,

in which situations do u go for starflake schema ?

6 Answers TCS,

How will the document be delivered to me?

0 Answers

how to call lookup qualifer in unconnected look;up

1 Answers BirlaSoft,

I have three same source structure tables. But, I want to load into single target table. How do I do this? Explain in detail through mapping flow.