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 |
What is blocking transformation?
what is pre and post sql and what is diff between source presql and target pre sql
Q. In source area, it is use complex query we have using 5 to 10 table we has been join now all join clolumn having indexes but still we having performance issue. how to fix the performnce issue of the query.
When we are using Dynamic Cache,which options we will select in session level?
how to delete duplicate records by using filter transfermation?
Explain where to store informatica rejected data? How to extract the informatica rejected data?
I HAVE A SOURCE FILE CONTAINING 1|A,1|B,1|C,1|D,2|A,2|B,3|A,3|B AND IN TARGET I SHOULD GET LIKE 1|A+B+C+D 2|A+B 3|A+B WHICH TRANSFORMATION I SHOULD USE
how can we update without using update transformation. wt is push down operation in informatica. which lookup gives more tuning performance. if so why.
hi real timers . iam waiting for ur reply regarding ETL TESTING
i have 1000 records in my dource table, the same i have in target ,but a new column added in target as "batchno", and this column adds no 10 for 1st 100 records and 20 for next 100 records and 30 next 100 records and vice versa. how to acheive this?
What are the basic needs to join two sources in a source qualifier?
What is the difference between view and materialised view?