February 1, 2014
Today we will discuss how to use a Mapplet In Informatica. Mapplet provides code re-usability, through which you can achieve same functionality in your different mappings.
This is a great feature as it helps in writing a code once and use in multiple places.
Overall Job Desc :
Below is a simple job description which helps you in understanding how to use Mapplet In Informatica.
This mapping takes input from the Employee table and will populate a target table with average salary for each department.
Step1: – Create a mapping and pull your source to the mapping designer area.
Step 2:- Create an independent Mapplet In Informatica and in mapplet Design area create mapplet input , aggregator and a mapplet output.
- In mapplet input specify what are gong to be your input ports
- And In aggregator define aggregate columns and output columns you can also use aggregate functions
- Finally specify the mapplet output output from the mapplet output will be sent back to the calling mapping.
Step 4: – In your designer area drag your mapplet and connect source with the mapplet input and mapping target with the mapplet output and you are done.
You can use the same mapplet in your multiple mappings to achieve same kind functionality.
Thanks For Reading
Author : Ankit Kansal & Nayan Naik