Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 7114 Views
- TCS, I also Faced
- E-Mail Answers
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 |
Scenario:- Below is the requirement. Source:- NAME ID Requirement RAVI 1 (no need to repeat as it ID is 1) KUMAR 3 (repeat 3 times as it ID is 3) John 4 (repeat 4 times as it ID is 4) Required Out Put:- Name ID RAVI 1 KUMAR 3 KUMAR 3 KUMAR 3 John 4 John 4 John 4 John 4 Scenario 2:- Source Data ID NAME 1,2 NETEZZA,ORACLE 3,4,5 SQL Server, DB2, Teradata Required Output:- ID NAME 1 NETEZZA 1 ORACLE 3 SQL Server 3 DB2 3 Teradata
What is mapplet and a reusable transformation?
what is size of u r database?
What are the join types in joiner transformation?
How can we eliminate duplicate rows from flatfile,explain?
What are the Differences between static cache and dynamic cache?
my source contain data like this eno ename phno 100 john 9989020508 101 ram 7246599999 i want to load the data into target is eno name phno 100 john (998)-9020-508 102 ram (724)-6599-999.
Implementation methodology
my source having 10 records but how can i load 20 records in target, i am not bother about duplicates?
whatis the default data driven operation in informatica
what is the diff b/w target load plan and cbl?
Hi all , I am planning for informatica S - PowerCenter 8 Mapping Design certification. I have rewuired the dumps for the same. if anyone of you having the same pl. share it with me. This will be of great help. My contact is : sagardev7@gmail.com TIA , Sagar
Teradata 
