For sequence generation we can use Sequence Generator and Informatica Variable port. I am just curious about which one is better to use on aspects like performance and etc. Any reference on this from Informatica text will be great.
Apart from performance please keep code readability and maintenance in mind. Sequence Generator is clearly visible just at first glance. Variable ports are hidden and visible only while editing the appropriate expression.