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 |
Diffrence between static and dynamic cache
how to calculate the optimum cache size in aggregator transformation?
There are 100 lines in a file. How to print line number 31-50 and 81-90 in unix with a single command.
(Integ) Start workflow: ERROR: User [practice] does not have sufficient privilege for this operation. how to solve this pls suggest me? THANKS in advance
expain about the tune parameters?
can anybody send me some real time screenshots of mapping in informatica powercenter. i will be vary thankful to him. my e-mail id :- prakashkumar.kumhar@gmail.com
difference between shortcut and reusable transformation?
What are the session parameters?
i have a table like empid ename year month sal 1 x 98 jan 500 1 x 98 feb 500 1 x 98 mar 500 1 x 99 jan 600 1 x 99 feb 600 2 y 98 jan 600 2 y 98 feb 600 2 y 98 mar 600 2 y 99 jan 700 2 y 99 jan 700 and so on i want to find out totsal for every emp on year wise plz help me
what is mean by throghput? in informatica
After a load is done to my target table, I need to insert a last row, which might be formed at some expression transformation and brought to target. Do I have to have separate mapping to be run after the 1st mapping? Or in a single mapping how to achieve this?
How to identify this row for insert and this row for update in dynamic lookup cache