Introduction to Mapplet In Informatica
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 transformation to find each dimension keys. Now, use this mapplet in each table mapping so that we can find total dimension keys in each table.
How is a Mapplet Created?
The process is defined in 3 steps:
- You need to add, connect, and configure transformations with a transformation logic.
- Save the mapplet with a unique name.
- 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:
- Every time while loading new data into a table, there occur 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.
- 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 does the same?
Subscribe to our youtube channel to get new updates..!
Both have one similarity that they work on data. But Mapping deals with those data on which a modification need 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 set of transactions, targets on which the data has to move.||It is a collection of transactions or set of rules applied on 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 on small amount of data||Mapplets are applied on Bulk data or Big data|
|Mapplet is a part of Mapping.|
Basic components of Mapping are
Basic Components of Mapplets are
[Related Page: 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 as parameters and variables. To define a transformation, there should be a source and destination objects which are called as Source Tables and Target objects respectively.
Mapplet applies on 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 for multiple times with different methods and the logic can be used on other transformations.
What are the limitations of Mapplets?
- You cannot connect a single Input port to multiple transformations.
- An Input transformation must get data from a single active user only.
- 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
- PowerMart 3.5-style LOOKUP functions are not supported in a Mapplet.
- 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?
- 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.
- 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 of 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|