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



If i have one source having 10 ports.In a mapping i use that source one target having that ten port..

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

If i have one source having 10 ports.In a mapping i use that source one target having that ten port..

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

If i have one source having 10 ports.In a mapping i use that source one target having that ten port..

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

Post New Answer

More Informatica Interview Questions

i have a source which relational.I am trying to populate to target flat file with one column for daily date which is sysdate. I want to populate the sysdate coulmn with DD/MM/YYYY format. kindly provide a solution for this..my clear that my target is flat file.

3 Answers  


1 lac of flat fles in source how to load target at a time?

4 Answers   Cap Gemini,


I have a scenario like - how can i load 1st record to Trgt1,2nd->Trgt2, 3rd->Trgt3 and again the cycle has to repeat with loading 4th->Trgt1,5th->Trgt2,6th->Trgt3?

3 Answers   ITC Infotech, TCS,


What is limitations of truncate and load option

1 Answers   Cap Gemini,


How to find from a source which has 10,000 records, find the average between 500th to 600th record?

3 Answers  






what is bitmap index? did u use it?and how to use it in informatica

1 Answers   IBM,


Can we insert and update a target table without using update strategy transformation?How?

4 Answers   Syntel,


What is the scenario which compels informatica server to reject files?

0 Answers  


how to load rows into fact table in data warehouse

0 Answers   Informatica,


I am not able to connect to the domain with the client although all services and databases are up and there is no network issue?

0 Answers  


what are the reusable tasks in informatica ?

11 Answers   CTS, HP, IBM, TCS,


Hi can any one tell me the difference between persistence and dynamic caches? On which conditions we are using these caches?

3 Answers  


Categories