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

1. Active maplet:

A maplet which is created with at least one active transformation is known as active maplet.

2. 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

1. pre (or) post stored procedure transformation
2. XML source qualifier transformation
3. Normalizer transformation
4. Maplet(nested maplet)

Keep the following instructions while using the following transformation in the maplet

1. When you want to used the sequence generator transformation you should use reusable sequence generator transformation
2. 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

• Rank Transformation in Informatica
• Aggregator Transformation in Informatica
• Expression Transformation in Informatica
• Lookup Transformation in Informatica
• ETL Project Architecture
• Interview Questions