· 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 |
Ports:
No Ports – We cannot add ports to SEQ Transformation.
All ports are disabled.
Sequence Generator in Informatica |
Properties:
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.
Comments
Post a Comment