A maplet is a reusable meta data object created with business logic using set of transformation
A maplet is created using maplet designer tool
There are 2 types of maplet
A maplet which is created with at least one active transformation is known as active maplet.
A maplet which is created with only passive transformation is known as passive maplet.
Informatica Interview Questions & Answers
The following objects are transformations can’t be used in the maplet
Keep the following instructions while using the following transformation in the maplet
Open the client power center designer from the tools menu select maplet designer.
From maplet menu select create
Enter the maplet name tax _cal _null _ validate
From transformation, menu select create
Select the transformation type maplet input
Enter the name MI _ tax _ cal click on create and done
Similarly create maplet output transformation
Create the transformation type filter and expression
Double click on maplet input transformation select the port tab
From tool bar click on add a new port
If you want to enrich your career and become a professional in Informatica, then visit Tekslate - a global online training platform: "Informatica Training" This course will help you to achieve excellence in this domain.
Header Name:
Empno
Ename
Job
Sal
Comm
Deptno
Click apply and click ok
From maplet input transformation copy the ports to the filter transformation develop the following filter condition
IIF((IS NULL(Ename)OR
IS NULL(Emp no)OR
IS NULL(Job)OR
IS NULL(Sal)OR
IS NULL(Comm)OR
IS NULL(dept no),FALSE, TRUE)
From filter transformation copy the ports to an expression transformation
Create an output port with the name total sal with the following expression
Sal+comm
From expression transformation copy the ports to maplet output transformation
From repository menu click on save
Create source and target definitions
Empno, ename, job,sal,comm.,dept no,total sal
Create a mapping with the name M_ employee _maplet
Drop the source and target definitions
From maplet sub folder drop the maplet beside the source qualifier
From source qualifier connect the ports to the maplet input
From maplet output connect the ports to the target
From repository menu click on save
You liked the article?
Like: 0
Vote for difficulty
Current difficulty (Avg): Medium
TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills in the market.