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 do you mean by blocking transformation?
Explain the types of transformations?
How to elaborate powercenter integration service?
What are batches?
What is the use of transformation?
What is flashback table ? Advance thanks
Enlist the advantages of informatica.
I have two different source structure tables, but I want to load into single target table? How do I go about it? Explain in detail through mapping flow.
what are the Methods For Creating Reusable Transformations?
How do you handle two sessions in Informatica
Explain the various test procedures used to check whether the data is loaded in the backend, performance of the mapping, and quality of the data loaded in informatica?
Make a note of the quantity vaults made in informatica?
lookup transformation with screenshots
How big was your fact table
What is the difference between STOP and ABORT options in Workflow Monitor?