Do you need to solve an issue with regards to sequencing or are you anticipating this question in an interview?
Anyway, consider solving a possible issue with Informatica instead of having to rely on an external procedure. You can than benefit from customized functionality (increments,resetting ....)
Ties Blom
Information analyst