Home / Informatica

Mapplet In Informatica

Rating: 4.0Blog-star
Views: 14592
by Ravindra Savaram
Last modified: February 15th 2021

A mapplet is a reusable data object representing a set of transformations and its logic to transform data among the tablets.

For example: Let's assume there is n number of tables. Our requirement is to select the dimension keys associated with each table. We now create a mapplet with a series of Lookup transformations to find each dimension key.  Now, use this mapplet in each table mapping so that we can find total dimension keys in each table.

If you want to enrich your career and become a professional in Informatica, then visit Mindmajix - a global online training platform: "Informatica Training" This course will help you to achieve excellence in this domain.


Introduction to Mapplet In Informatica

How is a Mapplet Created?

The process is defined in 3 steps:

  1. You need to add, connect, and configure transformations with a transformation logic.
  2. Save the mapplet with a unique name.
  3. Use  the mapplet in mapping

What are the features of  Mapplets?

  • A mapplet can define source definitions of key data and a source qualifier to provide data for mapping.
  • A mapplet can have no source definitions of data. Mapplet can accept those data also from a mapping process through the mapplet input ports.
  • A mapplet can have multiple transformations.
  • Data can be transformed into multiple pipelines. A mapplet can contain multiple groups of output ports/groups that can be connected with each other through different pipelines in the mapping.

Why Mapplets are created?

Mapplets are created for 2 main purposes. They are:

  1. Every time while loading new data into a table, there occurs some space in the source system, and every time a new transformation has to set on every mapping. Mapplets are created to avoid this repetition of creating transformation expression and to terminate the unwanted space formed in the source system.
  2. On every workflow running in the system, a batch id is formed based on the session timestamp by using a mapplet.

Do Mapplet and Mapping do the same?

Checkout Frequently asked Informatica Interview Questions

Both have one similarity that they work on data. But Mapping deals with those data on which a modification needs to be made whereas Maplets deals with multiple mappings. Other major differences are as follows:

It is a collection of source data objects linked by a set of transactions, targets on which the data has to move.
It is a collection of transactions or a set of rules applied to data.                                                               
The transformations cannot be reused.
The transformations can be reused.
It uses data sources and a transformation logic to transform the data to the target
One can create a series of transformation logics.
Mappings are applied to a small amount of data
Mapplets are applied on Bulk data or Big data
Mapplet is a part of Mapping.
The basic components of Mapping are
  1. Source tables
  2. Parameters and variables
  3. Target objects
  4. Transformations
The basic Components of Mapplets are
  1. Input
  2. Output

-----     Related Page: Informatica Metadata Manager     -----


As shown in the below figure, Mapping is all about connecting one database to another. These connections are made by defining a set of roles called transformation. Each transformation has definite validating elements defined called parameters and variables. To define a transformation, there should be the source and destination objects which are called Source Tables and Target objects respectively.


Mapplet applies to Mapped data. As shown in the figure, the source and target objects are defined and stored in the database. A logic to transform is defined by providing a Mapplet Input transformation that passes the data from Mapping to Mapplet and then a desired Mapplet output transformation that passes data from Mapplet to Mapping. Thus Input-Output transformations are revolved in a cycle making Mapping, transaction logic and data reused several times without affecting the data.

What does reusable transformation mean?

Reusable transformation means any transition logic or rule defined on a data to transform from source to destination through mapping can be provided multiple times with different methods and the logic can be used on other transformations. 

What are the limitations of Mapplets?

  1. You cannot connect a single Input port to multiple transformations.
  2. An Input transformation must get data from a single active user only.
  3. Depending on the source qualifiers- a set of rules defined on source data to extract data, Mapplet output ports use pipeline method for the single qualifier on source data or Join method for more than one qualifier
  4. PowerMate 3.5-style LOOKUP functions are not supported in a Mapplet.
  5. If Mapplets are changed from passive to active, the mapping defined on data is invalid. 

------       Related page: Informatica PowerCenter      ------

How to avoid mistakes while creating or dealing with Mapplets?

  1. Commenting on each Input and output transformations made in Mapplets is the best way to avoid mistakes. They will trigger us why we made them.
  2. Do not provide any alterations or changes on the source data datatype, data precision, or select the connected ports in I/O transformation, from passive to an active mapplet. 

List of Informatica Courses:

Mindmajix offers training for many other Informatica courses depends on your requirement:

 Informatica Analyst  Informatica PIM
 Informatica SRM  Informatica MDM
 Informatica Data Quality  Informatica ILM
 Informatica Big Data Edition  Informatica Multi Domain MDM


About Author

NameRavindra Savaram
Author Bio


Ravindra Savaram is a Content Lead at Mindmajix.com. His passion lies in writing articles on the most popular IT platforms including Machine learning, DevOps, Data Science, Artificial Intelligence, RPA, Deep Learning, and so on. You can stay up to date on all these technologies by following him on LinkedIn and Twitter.