Mapplet In Informatica

first
Hello Readers,
                               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.
Mapplet In Informatica

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.

Mapplet In Informatica

Mapplet In Informatica

  • 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