Hi,
I am unable to connect ports from two Active trasformations
to another active transformation ?
Why is it so? Why it is designed like that?
Some rules has been designed like this that is
We can't connect passive and another passive to active.Can
any one please letme know all these rules.
Ex:-
I am trying to connect
filter1 and filter2 to another filter.

Please answer me
Advance Thanks



Hi, I am unable to connect ports from two Active trasformations to another active transformation ..

Answer / priyank

Data from 2 active transformations and one active and one
passive transformations cannot be joined to any downstream
transformation as concatenation of data would not be
possible. We can join 2 active transformations using a
Joiner transformation.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More Informatica Interview Questions

Dimension Object created in Oracle can be imported in Designer Cubes contain measures

0 Answers  


What is session task and command task?

0 Answers  


What do you mean by enterprise data warehousing?

0 Answers  


How can i explain my project architecture in interview..? in Igate asked me tell me your project flow from source to target..?

1 Answers   Ameri Group, CGI, CTS, HCL, iGate, TCS, Wipro,


what are the settiings that u use to cofigure the joiner transformation?

2 Answers  






In which situation we will use persistant cache and shared cache in real time. plzsss answer with example

1 Answers   Wipro,


can every transfomation reusable?how?

2 Answers   Wipro,


without dynamic lookup how to insert new rows and update existing rows?

1 Answers   HP,


What is meant by LDAP users?

0 Answers  


What is a joiner transformation and why it is an active one?

0 Answers  


we have tables like c1 a c2 b c3 c c4 x c5 y and i need output like abcx in a single row and abcy in a single row? how do u do this?

2 Answers   Patni, Tech Mahindra,


What is data merging,data cleansing,sampling?

4 Answers  


Categories