Informatica Mapplet

Informatica is a data integration tool that is used for extracting the data required and transforming it to its server, and loading the same to the data warehouse. Informatica offers integration software and services to different businesses, industries as well as government organizations, including health care, telecommunication, finance and insurance services. In Informatica, there is a beautiful concept called a Mapplet. The greatest benefit of Mapplets is that they are created one time and can be used or shared between the developers. In this blog, let us know more about Mapplets, why we use them, features of Mapplets, components of the Mapplet in detail. So, let's quickly dive into the concept.

What is a Mapplet?

A Mapplet is an object that can be reused. It will be created in the Mapplet Designer. It includes a set of transformations and allows us to reuse transformation logic in more than one Mapping. Let us understand Mapplets with an example. Consider you have some fact tables which need a series of dimension keys. We can create a Mapplet with a series of Lookup transformations to find every dimension key. We can use this Mapplet in every fact table Mapping instead of recreating the same search logic in every Mapping. As a reusable transformation, any changes to the Mapplet are inherited from every instance of the Mapplet. A Reusable transformation refers to any rule or transition logic defined on the data that will be transformed from source to destination via Mapping, and it can be provided more than once with various methods and logic. it can be used for other transformations.

Mapplet is applicable to mapped data. The source object and the target object will be defined and stored in the database. A logic to be transformed is defined by offering a Mapplet Input that transmits the data from Mapping to Mapplet. After that, a desired Mapplet output transform transmits the Mapplet data to Mapping. So the Input-Output transformations will evolve into cyclic Mapping, transaction logic and reused data without any impact on the data.

Become a Informatica Certified professional by learning this HKR Informatica Training  !

Why Mapplets?

The Mapplets are created to serve two primary purposes:

Whenever we load new data into a table, some space occurs in the source system, and whenever a new transformation is required to be configured on each Mapping. Mapplets are created to prevent this repetition of the creation of the transformation expressions and to end the unwanted space that is formed in the source system. 
On each workflow that is running in the system, a batch id will be formed according to the timestamp of the session using a Mapplet.

Become a Informatica Certified professional by learning this HKR Informatica Training In Hyderabad  !

Informatica Certification Training

  • Master Your Craft
  • Lifetime LMS & Faculty Access
  • 24/7 online expert support
  • Real-world & Project Based Learning

Informatica Mapplet features: 

  • A Mapplet is used to define key data source definitions as well as a source qualifier for providing the data for Mapping.
  • A Mapplet may not have the source definition of the data. Mapplet may accept this data as well from a mapping process via Mapplet input ports.
  • A Mapplet may have several transformations. 
  • The data may be transformed into several pipelines. A Mapplet may include several groups of output ports/groups which may be connected to one another via various pipelines in the Mapping.

Want to know more about Informatica ,visit here Informatica Tutorial !

Mapplet Components:

For using a Mapplet in Mapping, we must configure the Mapplet for input and output. Apart from the transformation logic we are configuring, a Mapplet includes the following components:

  • Mapplet ports
  • Mapplet input
  • Mapplet output 
Mapplet Ports:

It will be available only in the Mapping Designer. The Mapplet ports comprise the input ports of the input transformations and the output ports of the output transformations.

Mapplet Input:

The Mapplet input may come from the source definition or from the Input transformation within the Mapplet. Several pipelines can be created in a Mapplet. Utilize several source definitions as well as the input transformations or source qualifiers. Alternatively, you can use a mixture of input transformations and source definitions.

Mapplet Output:

The Mapplet output consists of transformation for passing the data through the Mapplet into the Mapping. At Least one output transformation is included in the Mapplet that includes at least one connected port in the Mapplet. Every port connected in the output transformation displays as a Mapplet output port in the Mapping. Every output transformation in the Mapplet is displayed as the output group in the Mapping. The output group may transmit data to several pipelines within the Mapping.

Subscribe to our youtube channel to get new updates..!

Creation of a Mapplet in Informatica:

The creation of Mapplets involves three steps.

  • First, we must add, connect and then configure the transformations using a transformation logic.
  • Then we need to save the Mapplet using a unique name.
  • Now we can use this Mapplet in the Mapping.
     

When dealing with the Mapplets, mistakes can be avoided by:

  • One of the best ways to avoid mistakes in Mapplets is to comment on every input as well as output transformation that is made in Mapplets so that they will remind us why we have made them.
  • Avoid making modifications to source data datatype, data accuracy or select ports that are connected in the I/O transformation, from the passive to active Mapplet.
     

Follow the rule and guidelines while adding transformations to the Mapplet:

  • When you are using the sequence generator transformation, you should use the reusable sequence generator transformation.
  • When you are using the stored procedure transformation, you should configure the stored procedure Type as Normal.
  • The PowerMart, 3.5 style LOOKUP functions, cannot be included in a Mapplet.
     

Following are the objects that cannot be included in a Mapplet:

  • COBOL sources
  • Normalizer transformations
  • Other Mapplets
  • Target definitions
  • XML sources
  • XML source qualifier transformations
  • Pre and post-session stored procedures
  • Non-reusable sequence generator transformation
     

While reusable shortcuts and transformations in the Mapplet can be used, for protecting the Mapplet validity, use a copy of the transformation rather. Reusable transformations or shortcuts inherit modifications to their original transformations. This could disable the Mapplet and Mapping, which utilizes the Mapplet.

Top 30 frequently asked Informatica Interview Questions !

Informatica Certification Training

Weekday / Weekend Batches

Conclusion:

In this blog, we have learned about Mapplets, why we use Mapplets, Mapplets features, components of a Mapplet and how to create a Mapplet. We hope you found this information helpful!. For more blogs like this, stay tuned to HKR Trainings. 

Related Articles:

Find our upcoming Informatica Certification Training Online Classes

  • Batch starts on 5th Dec 2022, Weekday batch

  • Batch starts on 9th Dec 2022, Fast Track batch

  • Batch starts on 13th Dec 2022, Weekday batch

Global Promotional Image
 

Categories

Request for more information

Gayathri
Gayathri
Research Analyst
As a senior Technical Content Writer for HKR Trainings, Gayathri has a good comprehension of the present technical innovations, which incorporates perspectives like Business Intelligence and Analytics. She conveys advanced technical ideas precisely and vividly, as conceivable to the target group, guaranteeing that the content is available to clients. She writes qualitative content in the field of Data Warehousing & ETL, Big Data Analytics, and ERP Tools. Connect me on LinkedIn.