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 all the deliverables of ETL informatica power center project? what are all updated or created by etl developer as his everyday activities?
Tell me about Propagate functions in informatica
Explain sql transformation in script mode examples in informatica
Why is sorter an active transformation?
What is olap (on-line analytical processing?
Can you generate sequence numbers without using the sequence generator transformation?
What is a filter transformation and why it is an active one?
Briefly explain the aggregator transformation?
5. Consider the following products data which contain duplicate rows. A B C C B D B Q1. Design a mapping to load all unique products in one table and the duplicate rows in another table. The first table should contain the following output A D The second target should contain the following output B B B C C
What is substr in informatica?
Explain scd type 3 through mapping.
what is the complex transformation you used in informatica
How do you change a non-reusable transformation to reusable transformation?
What is confirmed fact in dataware housing?
Whats there in global repository