Using Oracle sequence to generte ID while writing in file

[vidya821]

Hi All,

I have this requirement wherein input file has below format

Person_ID | Name | DOB

Now, the Person_ID value in the input file can be blank sometimes and so i need to assign Person_ID generated via Oracle sequence,

Can anyone please tell me what is best way to call Oracle sequence for this matter.

(One way is i can create Code Routine in Talend to call every time when Person_ID is blank or null,

The only thing is i have to open, create and close DB connection in the code everytime it is called )

[Anonymous]

To be honest, it doesn't matter where you are writing your data, it will be quicker to carry out the intermediary processing in memory rather than writing to a file. Are you not writing the generated ID to the database at all? Not even an update to the record set you are querying?

[vidya821]

Thanks, my task is till file generation, what exactly is to be done with the file further - am not sure 🙂
anyways i have implented using tHash, now checking the performnce...hope it comes out good

Moreover i m thinkig of using sequence generator in talend to improve performance

[Anonymous · Accepted solution]

The sequence generator in Talend would have been my suggestion earlier had I known it was just for a file, but I suspect that you will need to ensure that numbers are not repeated. A sequence handled by the database is better for that. If your IDs can be repeated and there is no need to do anything inside the database, use a Talend sequence.