INFORMATICA_MAPPLET_REUSABLETRAN_NORMALIZER_SEQUENCEGEN_UNIONALL

MAPPLET_REUSABLE TRANSFIRMATION

====================================

1. Create a Mapping like below which uses mapplet and reusable transformation

1. Reusable Transformation creation

1. Mapplet creation with multiple transformations

Normalizer Transformation:

==========================

1. Mapping creation like below

 

Expression Transformation Preparation

Noramlizer Transformation Preparation

 

Sequence Generator Transformation:

=================================

Scenario 1:

Map only current value to the destination and observe constant value population.

Use the below sequence generator properties:

StartVal : 1  Increment Val : 1  Endval : 5 Cycle : yes Currentval : 1 Reset (Check it)

Scenario 2:

In the above mapping, use nextval and currentval and pass to target.

Union Transformation:

=======================

Three destinations like below and merging data into a destination.