Generating sequence numbers without using Sequence Generator transformation

1. Create a target table with a field name SEQ_NO for sequence number.
2. Design the Mapping as shown above.
3. In the Expression transformation create a variable port and increment it by 1.
• V_Count=V_Count+1
4. In the Expression transformation create a output port and assign variable port to it.
• O_Count=V_Count
5. Connect O_Count to SEQ_NO.