Pages

Monday, March 18, 2013

What is CURRVAL, NEXTVAL in Sequence Generator Transformation?


CURRVAL = NEXTVAL + Increment by Value property
If you connect CURRVAL port without connecting the NEXTVAL, then the CURRVAL will give you constant value.
If you connect CURRVAL, Informatica process one row at a time – can be a performance issue.
NEXTVAL – generates sequence numbers when you connect this port to a transformation.
If you want to load 2 targets with the same sequence number
Connect the NEXTVAL port to a transformation and then connect that transformation to the 2 targets.
If you want to load 2 targets with the unique sequence number
Connect the NEXTVAL port to two different targets or two different pipelines which has those 2 targets.

No comments:

Post a Comment