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
Answer Posted / 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 View All Answers
what are the different types of transformation available in informatica. And what are the mostly used ones among them?
What is event and what are the tasks related to it?
How to differentiate between the active and passive transformations?
What is the Rank index port in Rank transformation?
What are the differences between source qualifier and joiner transformation?
How many input parameters can exist in an unconnected lookup?
What are roles and groups and benefits of using them?
Source and Target are flat files, Source table is as below ID,NAME 1,X 1,X 2,Y 2,Y On Target flat file i want the data to be loaded as mentioned below ID,NAME,REPEAT 1,X,2 1,X,2 2,Y,2 2,Y,2 How to achieve this, Can i get a map structure
explain one complex mapping with logic? sales project?
How can informatica be used for an organization?
What are the uses of etl tools?
How do you promote a non-reusable transformation to reusable transformation?
What is the need of etl tools?
What happen if you have 3 ports in SQ and 4 ports in SQL override of SQ( provided all ports are in same order and they are connected with proper source and target)? Also what happens when I have 4 ports and will extract 3 values in SQloverride.. What will be the value in 4th port ?
What do you mean by blocking transformation?