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 |
How to convert flat file into xml file? How to tune joiner?
When do we use dynamic cache and static cache in connected and unconnected lookup transformations?
When we are using Dynamic Cache,which options we will select in session level?
What is the diff. b/w informatica versions 8.1.1 and 8.6.1?
what is the size of u r project? and what is the size of source file?
I am having source ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI Target ENO ENAME LOC 1 A PUNE 2 B MUMBAI 3 C CHENNAI If a new record coming from source from same location it should directly go to specified location in target at begining EX:if Eno with 4 coming from same Pune, It should directly load into the Pune location col with '|' symbol. Help me its very urgent
In a table there are 1 million records there in which 3 records are duplicate how will you find out those 3 records?
what is the Default Source Option For Update Strategy Transformation?
Find a way to implement the following logic : You have column like : Column 1 AA|BB|CC DD|EE|FF WW|AA I need to get the length of the column without the ‘|’ .
Can you start a session inside a batch individually?
two types of data are there . one is mainframe and the other is ascii format . in informatica how can you get both the data in a single format in ascii .
How is union transformation utilized?