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
what is Active lock explain
What is the difference between power center and power mart? What is the procedure for creating independent data marts from informatica 7.1?
How to join three sources using joiner?
What is the function of aggregator transformation?
Hello, Can you please send the admin and advanced mapping design sample questions to ns_sharmin@yahoo.com?
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?
How to configure mapping in informatica?
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 are the new features of informatica 9.x developer?
what are factless facts? And in which scenario will you use such kinds of fact tables.
What is a router transformation?
What are active transformations.
What is rank index in rank transformation?
Dimension Object created in Oracle can be imported in Designer Cubes contain measures
What do you mean by DTM and Load manager and what is difference between load manager and load balancer?