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.
The process is defined in 3 steps:
Mapplets are created for 2 main purposes. They are:
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.
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.
[Related page: Informatica PowerCenter]
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|
Free Demo for Corporate & Online Trainings.