Informatica Reference

Archive for August 2012

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.

Non-Reusable – If the Value is 0 – It doesnt Cache Values. Informatica reads the start value form the repository and then keeps generating the sequence values. At the ene of the session it updates the current value to Start Value or Lastgeneratedsequence+1 (based on the Reset Option)

If the Value is > 0 then Informatica reads the start value and caches the number of values based on the Number of Cached Values and then updates the Current value in the repository. It will again go to the Repository if all the values are used. At the end of the session it throws away any unremaining Sequence Numbers which were not used.

In INFA the Commit Interval Property help Integration Service commits rows to targets based on the commit interval.
If the session fails for some reason then,the Integration Service rolls back to the last commit point, The roll back depends on the commit interval configured in the session.
In your case, set the Commit interval = 90, and verify it.
There are two Commit types in INFA
1.Target Commit Interval
2.Source Commit Interval.