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.
- 3 Answers
- 6233 Views
- TCS, I also Faced
- E-Mail Answers
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 what is informatica metadata and where is it stored?
What will happen if the select list columns in the custom override sql query and the output ports order in sq transformation do not match?
What is the difference between router and filter?
When do you use sql override in a lookup transformation?
lookup transformation with screenshots
What is a sequence generator transformation?
What is the way to execute pl/sql script using informatica mapping?
What are the reusable transformations?
How to do unit testing in informatica? How to load data in informatica ?
Suppose we have two source qualifier transformations sq1 and sq2 connected to target tables tgt1 and tgt2 respectively. How do you ensure tgt2 is loaded after tgt1?
What are the mapping parameters and mapping variables?
What is persistent lookup cache?
where to store informatica rejected data?
How do you load only null records into target? Explain through mapping flow.
HOW TO PROCESS THE ROWS FROM JOINER AND EXPRESSION TRANSFORAMTION TO SORTER TRANSFORMATION
