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.
Informatica Interview Questions & Answers
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 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
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
- Rank Transformation in Informatica
- Aggregator Transformation in Informatica
- Expression Transformation in Informatica
- Lookup Transformation in Informatica
- ETL Project Architecture
- Interview Questions