Generate sequence numbers in Informatica without using sequence generator transformation.

Mapping:

Create sequence numbers without using sequence generator transformation.

Business Requirement:

This is Informatica PowerCenter mapping example to generate sequence number without using sequence generator tranform, the logic is implemented using unconnected look-up tranformation and expression transformation.

Implementation Guidelines:

In the expression transformation create a variable port for impelemting the logic:-

iif(isnull(v_EMP_KEY) or v_EMP_KEY = 0,iif
(isnull(:LKP.lkp_TGT_EMP_DIM_MAX_SK(-1)) ,0, :LKP.lkp_TGT_EMP_DIM_MAX_SK
(-1)),v_EMP_KEY) + 1

Link foward the EMP_KEY to the target instance as shown in figure 1.