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
My source is delimited flat file Flat file data is H|Date D1|ravi|bangalore D2|raju|pune T|4 The data will be send to target if the fallowing two conditions satisfied 1.The first row Date column is equal to SYSDATE 2.Last record second port equal to number of records. How to achieve?
Suppose we configure sorter transformations in the master and detail pipelines with the following sorted ports in order: item_no, item_name, price. When we configure the join condition, what are the guidelines we need to follow to maintain the sort order?
What is meant by query override?
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.
How might one distinguish in the case of mapping is right or not without associating session?
4 yrs etl devloper roles and responsibilities?any body give solutions
How many ways are there to create ports?
How you prepared reports for OLAP?
What all are steps in up gradation of Informatica server?
What if the source is a flat-file?
Have you worked with/created Parameter file
How we can create indexes after completing the load process?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
What is Data Caches size?
Mine is Insurance Domain, So interviewer asked about terms like underwriting, disbursement amt, Reinsurance