how to work with mapplet designer in informatica?
Answers were Sorted based on User's Feedback
Answer / krishna
a Mapplet is a set of transformations which can be reused
across multiple mappings. a mapplet cannot have a target.
it can start with a source or a mpplet i/p transformation
and it should end with a mapplet output transformation. you
cannot have a transaction control transformation as part of
a mapplet. also a seq.generator is not permitted.
Is This Answer Correct ? | 26 Yes | 1 No |
mapplet is is a set of transformations wch can be
reused.mapple can be slected in mapplet.
Is This Answer Correct ? | 29 Yes | 8 No |
Answer / padmavathi
In Mapplet Designer we will get 2 extra Transformations
like Mapplet Input & Mapplet Output we have to use these as
Input & output Transformations in pipeline, in Middle of
pipe line we have to implement our logic by using
Transformations acc to requirment. This mapplet is
reusable,in Mapping Designer where ever we require tht
logic we can use mapplet directly need not to implement
total logic again just we have to link in/out ports.
Is This Answer Correct ? | 23 Yes | 3 No |
Answer / usha
mapplet designer which is used to create a mapplet..
mapplet is a set of reusable transformation logic...
mapplet contains mapplet input tarnsfromation ,
mapplet output tarnsfromation,
and some reuasable transformation in the middle of mapplet
i/p and o/p.......
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / ryan jasper diego
1. Tools->mappletdesigner->create->give a name
2. From tr menu->create->mapplet input
3. In, mapplet input tr create required ports
4. Create required group of tr like sorter,exp
5. Drag the ports from mapplet input to the tr
6. Create mapplet output t/r
and finally save the mapplet in the repository
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sankar
Mapplet Contains set of Transformations.This Transformations
are reusable transformations and mapplet also. any ware we
can use this mapplets in mapping. Mapplet having Input and
Output mapplet in this mid of we can use different
transformations based on the requirement.
Is This Answer Correct ? | 1 Yes | 0 No |
sample mappings for scd1,scd2 and scd3
What are the uses of a Parameter file?
Explain Dataware house architecture .how data flow from intial to end?
source : xml file target: xml file how can we check data loaded into target xml file using writing sql query. pls help on this asap.
0 Answers Cap Gemini, Cognizant,
performance wise which one is better in joiner and lookup transformation?why?explain clearly?
explain any diffcult scenario that u have faced in your experience... or explain any complex maping u have developed?
we have 20 records in source system, when we run for the 1st time, it should load only 10 records into the target, when you run for the second time it should load another 10 record which are not loaded. How do we do that? Can we write a SQL query in source qualifier to do it. This q' is asked in one f the interviews. Please let me know if anyone knows. Thanks
I am getting five sources in a day and i donot know when i get them. i need to load data into the target and run the session. but here i can't keep the session in running or can't stop the session. plz help me
Q. Informatica workflow, it is running beyond two hours for last couple of runs, normally it completed less then 30 min., hardly 40 min, last couple of run crossing 2 hours and more in that workflow only one session. now it is aasign to you that how to idenitfy the performance issue of the sesion of production.
how can one come to know wether the records loak into the target if we use update strategy
Define filter transformation?
we r using aggregator with out using groupby?
7 Answers HSBC, Principal Finance,