Mapplet in informatica LEARNOVITA

Mapplet In Informatica | Purpose and Implementation of Mapplets | Expert’s Top Picks | Free Guide Tutorial

Last updated on 02nd Nov 2022, Artciles, Blog

About author

Bharathi Suresh (Talend ETL Developer )

Bharathi Suresh has extensive experience with SQL, Teradata, data warehousing, Talend Open Studio, MDM & MDM, ETL, and mySQL. His articles assist in sharing information and abilities in core fields and provide students with informative knowledge.

(5.0) | 19528 Ratings 2392
    • In this article you will learn:
    • 1.What is Informatica Mapplet?
    • 2.Why do use a Mapplet in Informatica?
    • 3.How to create Mapplet in Informatica?
    • 4.How to edit Informatica Mapplet?
    • 5.How to debug Mapplet in a Informatica?
    • 6.How to open a Mapplet in Informatica?
    • 7.What are features of a Mapplets?
    • 8.Do Mapplet and Mapping do the same?
    • 9.What are limitations of Mapplets?
    • 10.Conclusion.

What is Informatica Mapplet?

The Informatica Mapplet is a very useful Informatica PowerCenter feature. Reuse is essential in any programming language for creating efficient and fast software. Mapplets provide these benefits when used in conjunction with an Informatica PowerCenter.Mapplets are reusable objects with logic and transformations that are very similar to traditional mapping. The only difference here is a re-use. When you want your mapping logic to be reusable across multiple mappings you must use mapplet.

Why do use a Mapplet in Informatica?

There are two primary reasons to use a mapplet in Informatica, which are as follows:

  • When loading new data into a table the source system may be left with some empty space. And for each mapping a new transformation must be applied. As a result mapplets are created and used to avoid the creation of transformation expressions being repeated. They also aid in the elimination of unnecessary space in a source system.
  • The second reason is that by using a mapplet a batch ID is generated for each workflow that is running in the system based on the timestamp.

How to create Mapplet in Informatica?

  • Open a folder or connect to one where you want to make a mapplet.
  • Click a from a menu section.
  • Designer of Mapplets.
  • Choose Create an option from the available menu.
  • A popup will appear asking you to name the mapplet.
  • Enter your preferred name and click OK.
  • Go to the menu select Transformations and then Create an option.
  • To create a mapplet you must first choose a transformation type.
  • Select a Mapplet Input from the drop-down menu.
  • Give this name transformation.
  • Click Create then select a Done.
Mapplet

How to edit Informatica Mapplet?

A Mapplet Designer can be used to edit a mapplet. When a mapplet is saved, the designer helps to validate the changes. All instances and shortcuts are affected as a result. If you want to see any shortcuts or mappings that may be affecting the changes you make in a mapplet you can:

  • Right-click on a mapplet in the Navigator .
  • Then click on Dependencies.
  • You can make the following changes to a mapplet that won’t affect its validity or session.
  • Add additional input or output ports.
  • Change the comments in the input or output or the names of the transformations.
  • Modify the comments or the port names.
  • Change the appearance of properties , comments or names.
  • Change the transformations’ default port values.

How to debug Mapplet in a Informatica?

Informatica designer includes a feature for debugging a mapplet in Informatica. This aids in the debugging and evaluation of any existing mapplets. The only requirement here is that it be a valid mapplet:

  • A Designer of Open Informatica.
  • Double-click on a mapping to open it.
  • A source qualifier will be opened and a target definition table with mapping will be displayed.
  • Now select a menu item.
  • Select a Debugger.
  • Select a Start Debugger.
  • Click Next in a debug mapping window.
  • A session type selection window will appear in the following window. You can choose between an existing reusable session an existing session and creating a new session instance.
  • Next should be clicked.
  • A Discard Target Data option will appear in the next window. If you don’t need to load any data into a target table while debugging you can select this option.
  • Select a Finish option. Debugging will now begin.

How to open a Mapplet in Informatica?

  • Mapplets and mapplet ports are displayed differently in the Mapping and Mapplet Designers. When using a mapplet in mapping the mapplet object showcases are only ports from Output and Input transformations. These are referred to as mapplet output and mapplet input ports respectively.
  • The mapplet displays input ports from input transformations as well as output ports from output transformations. In the mapping designer you can expand a mapplet by selecting it clicking Mappings and then selecting Expand.
  • This allows the mapplet to expand for viewing purposes. Shaded transformation icons are displayed in an expanded mapplet.
  • All transformations in a mapping and mapplet can be iconized or opened. Remember that when a mapplet is expanded you will be unable to edit any property navigate to other folders or save a repository.

What are features of a Mapplets?

  • A mapplet assists in providing data for mapping by defining source definitions of integral data as well as source qualifiers.
  • Data can be transformed into various pipelines.
  • A mapplet can be made up of several groups of output ports that are connected to one another via various pipelines in a mapping.
  • A mapplet may contain no source data definitions.
  • Through the various mapplet input ports, mapplets can accept data from a mapping process.
  • A mapplet can have multiple transformations.

Do Mapplet and Mapping do the same?

Mapplets and Mapping have one thing in common they both work with data. However while mapping deals with data that needs to be modified maplets deal with multiple mappings. Aside from that here is a table that shows the distinction between these two:

Mapping
    MappletsMapping
    These are a collection of the set of rules or transactions applied to a data. These are a collection of a source data objects that are linked through set of targets, transactions on which a data has to move.
    The transformations in the mapplets can be reused. The transformations in a mapping cannot be reused.
    Can create a series of a transformation logics. These use data sources as well as a transformation logic to be transform the data to a target.
    Big data or large amounts of data can be used with mapplets. Mappings can be applied to a small data.
    The basic components of a mapplets include the input and output. A mapping is made up of four main parts: the source tables, the transformations, the parameters and variables, and the objects at the other end.

What are limitations of Mapplets?

  • It is not possible to connect a single input port to multiple transformations.
  • If mapplets are changed from passive to active the mapping described on the data becomes invalid.
  • An input transformation should only receive data from one active user.
  • Mapplet does not support the LOOKUP functions found in PowerMate 3.5.

Conclusion:

Now that you know what an Informatica Mapplet is and how it works it’s time to start using it in your projects. Creating viewing and debugging an Informatica Mapplet will be a breeze if you review the aforementioned guidelines.

Are you looking training with Right Jobs?

Contact Us

Popular Courses