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 |
while creating the scd mappings. we will mention flag value. what exactly the use of defining the FLAG VALUE. Please explaine indetaile
What is the difference between a repository server and a powerhouse?
what is data driven?
Hi If i had source like unique & duplicate records like 1,1,2,3,3,4 then i want load unique records in one target like 2,4 and i want load duplicate records like 1,1,3,3 then can any body please send me what is th scnario. my mail i shek.inform@gmail.com
how can we calculate fact table size?
Kimball and Inmon methodologies?
PLS REAL TIMERS IAM WAITING FOR FAVOROBLE REPLY..REGARDING ETL TESTING INFORMATION...ETL TESTER NEEDS ETL DEVOLPMENT KNOWLEDGE OR NOT..?. IF HE NEED DEVLPMNT KNOW WHAT HE LEANR FIRST... AS A DEVOLOPER U KNOW THE ETL TESTING PROCESS.. PLS EXPLAIN IN DETAIL THANK U
What is domain in terms of informatica?
scd methodology?
What are the diffrences between joiner transformation and source qualifier transformation?
How do you load first and last records into target table? How many ways are there to do it? Explain through mapping flows.
As union transformation gives UNION ALL output, how you will get the UNION output?