If i have one source having 10 ports.In a mapping i use that
source one target having that ten ports.Data from 5 ports
are going to target through a mapplet and another 5 ports
are going to target through another mapplet.Both 2 mapplets
are intially passive in nature.But presently my requirment
to convert on mapplet to ACtive.How can i do it.
Answers were Sorted based on User's Feedback
Answer / akash
First pass the ports through active mapplet and then use a
joiner to pass only those records which are coming out from
active mapplet. Then send the remaining 5 ports to passive
mapplet.
Ex:
we have 5 records which have id:
1
2
3
4
Out of these 4 only records having id = 1, 3, 4 pass
through the active mapplet where we use 5 ports.
Then we can use a joiner with inner join condition on id
field to get output as records having id = 1,3,4
Now the remaining 5 ports are entered to the passive
mapplet and the result of this mapplet will be required
result.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / mohan
add active transformation to mapplet or if mapplet has
already an active/passive transformation then we can add
some filters/confitions to it then mapplet becomes an
active mapplet
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / sukanta
Question modified like this
If i have one source having 10 ports.In a mapping i use that
source only once and a target having that ten ports.Data
from 5 ports are going to target through a mapplet and
another 5 ports are going to target through another
mapplet.Both 2 mapplets are initially passive in nature.But
presently my requirement to convert one mapplet to Active
and second one will remain passive.How can i do it.
| Is This Answer Correct ? | 0 Yes | 0 No |
what type of documents you receiving from client later wt can you do? what type of documents have to prepare?
What is the actual work done in Development and in the production depts in building a datawarehouse. Which dept is more interesting and career oriented .
checkout and checkin in informatica 8.6
Transformer is a __________ stage option1:Passive 2.Active 3.Dynamic 4.Static
What is the difference between a table and the materialized view?
Hi experts, table 1 has 10 records, table 2 has 5 records select * from table1, table2; What is the output for this query???....plz answer
Suppose on 1st Nov 2010 you had created a mapping which includes huge aggregator calculations and it is under process for next two days. You will notice that even on 3rd day also its still calculating. So without changing a logic or changing a mapping How will you troubleshot or to run that mapping? Explain the steps
How to extract original records at one target & Duplicate records at one target? {with out using EXPRESION transformation and sequence generator transformation?}<-this is important
How to go to the older version for a mapping?
How to do Integration testing in Informatica?
In which scenario did u used Mapping variable?
Dovelopment work (mapings,workflows)and unit testing also done in informatica ,then wt we do ? pls give me detail?