Maplet and Types of Maplet
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
- Active maplet:
A maplet which is created with at least one active transformation is known as active maplet.
- Passive maplet:
A maplet which is created with only passive transformation is known as passive maplet.
Limitation:
The following objects are transformations can’t be used in the maplet
- pre (or) post stored procedure transformation
- XML source qualifier transformation
- Normalizer transformation
- Maplet(nested maplet)
Keep the following instructions while using the following transformation in the maplet
- When you want to used the sequence generator transformation you should use reusable sequence generator transformation
- You should use the stored procedure transformation with the type
Procedure:
Open the client power center designer from 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
These core tutorials will help you to learn the fundamentals of Informatica. For an in-depth understanding and practical experience, explore Informatica Training Online.
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
Design a mapping with maplet:
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
For indepth understanding of Informatica, click on