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.
Answer Posted / 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 |
Post New Answer View All Answers
Explain joiner transformation in informatica
Describe data concatenation?
lookup transformation with screenshots
What is informatica worklet?
What is InformaticaPowerCenter?
What all join we can perform in LOOKUP transformation?
One of the optimizing technique to improve the session performance is push down optimization,by using push down optimization we push as much as transformation logic to source/target database,but this degrades the d/b performance,how to overcome this?
To Provide Support For Mainframes Source Data, which Files Are Used As A Source Definitions?
What are the advantages of informatica?
How you know when to use a static cache and dynamic cache in lookup transformation?
How would you join a node to the already existing domain?
How to load the data from people soft hrm to people soft erm using informatica?
What is the difference between writing a joiner query in ANSI style and THETA style?
Differentiate between joiner and lookup transformation?
Tell me can we override a native sql query within informatica? Where do we do it? How do we do it?