✍ Kashif M
Trends

Sunday, 8 September 2013


Sequence Generator in Informatica


By on September 08, 2013


· Passive Transformation

· It is used to generate sequence numbers (to create Primary Key values)

· By default, it creates NEXTVAL and CURRVAL port names which are in disabled state.

· We cannot add new ports.

· Sequence generator does not allow any inputs, allows output only.



STEPS:

Define Source

Define Target

Define Mapping – Drag the source (EMP), target (should have an extra field for sequence number).

Rep -> save
Sequence Generator in Informatica
Sequence Generator in Informatica



Ports: 

No Ports – We cannot add ports to SEQ Transformation. 

All ports are disabled. 

Sequence Generator in Informatica
Sequence Generator in Informatica

Properties:
Sequence Generator in Informatica
Sequence Generator in Informatica



Start Value: Start value is 0 by default. Used when the Cycle option is checked. It is used for starting the next cycle.

Increment By

End Value

Cycle

Current value: The beginning value of the sequence. By default it is 1.




Kashif
mkashu: Sequence Generator in Informatica
Review : Kashif | Kashif
Update: September 08, 2013 | Rating: 4.5

Comment for "Sequence Generator in Informatica"

0 comments

Post a Comment

Blog Archive