Oracle sequence can be used in a Pl/Sql stored procedure, which in turn can be used with stored procedure transformation of Informatica.
Informatica sequence is generated through sequence generator transformation of Informatica. It depends upon the user needs but Oracle sequence provides greater control.
I am also confused between both these options. But after reading this post all my doubts have been cleared and also got a chance to know which is a better option. Thanks for sharing the exact point of difference.
ReplyDeletesap upgrades