oracle sequence or surrogate key generator
Posted: Tue Nov 24, 2009 11:30 pm
HI,
I am in a position to decide whether to use the surrogate key generator or oracle sequence for creating unique ids.
My requirement is to generate sequence numbers based on the existing max number we have in the table.
I have done that using oracle seuqence--i.e in the insert statement, i have used user-defined sql and in the values i have passed <sequence.nextval). it was simple and had no problems.
Now in a different project i am being asked to evaluate the pros and cons of using oracle sequence and surrogate key generator as surrogate key generator is being used in different ETL projects which are already existing.
can anyone help..
I am in a position to decide whether to use the surrogate key generator or oracle sequence for creating unique ids.
My requirement is to generate sequence numbers based on the existing max number we have in the table.
I have done that using oracle seuqence--i.e in the insert statement, i have used user-defined sql and in the values i have passed <sequence.nextval). it was simple and had no problems.
Now in a different project i am being asked to evaluate the pros and cons of using oracle sequence and surrogate key generator as surrogate key generator is being used in different ETL projects which are already existing.
can anyone help..