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

What is the difference between a repository server and a powerhouse?

0 Answers  


what is the predefined port in dynamic lookup

2 Answers  


What type of sorting algorithm does the Sorter Transformation use, to do its sorting Operation? 1. Bubble sort 2. Insertion sort 3. Shell sort 4. Merge sort 5. Heapsort 6. Quicksort 7. Bucket sort

3 Answers  


What are the main features of Oracle 8i with context to datawarehouse?

0 Answers  


What is confirmed dimension and fact?

7 Answers  






what is fact and what types of fact tables is there

4 Answers   Cap Gemini,


i have a source table and 3 target table. when session runs first time-1st tgt second time-2nd tgt third time-3rd tgt fourth time-again 1st target. so no

4 Answers   HCL,


Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.

0 Answers  


how can we run workflow with pmcmd?

3 Answers   Wipro,


Which are the different editions of informatica powercenter that are available?

0 Answers  


Limitation of REPLACESTR. Is there any character limitation to it.

1 Answers   CTS,


Diff b/w ShortCut and reusabel Object ?

4 Answers  


Categories