Oracle read and write rates
Posted: Tue Jul 19, 2016 10:50 am
Greetings -
I've been in the forums all morning, and can't quite find a problem similar to the one I'm encountering.
I have a simple job that uses an Oracle connector to read a table for a few employee details. It also calls an Oracle procedure to generate a user id, for any records that don't have one.
The data is then sent through a transformer, and finally does a table updated.
The problem I've encountered is that it's (remotely) possible for the procedure to generate the same ID if two similar names come through within the same job run. (For example Tom Smith and Terry Smith would both generate smitt10, instead of smitt10 and smitt11.)
I've experimented with Record Count, Array Size, and Isolation level. But so far haven't been able to get the records to create unique IDs in the situation I illustrated above. I guess basically what I need is for the job to read a single record and commit it, before it brings the next record through the process. Any suggestions on how I might accomplish this?
Thanks in advance.
Tom
I've been in the forums all morning, and can't quite find a problem similar to the one I'm encountering.
I have a simple job that uses an Oracle connector to read a table for a few employee details. It also calls an Oracle procedure to generate a user id, for any records that don't have one.
The data is then sent through a transformer, and finally does a table updated.
The problem I've encountered is that it's (remotely) possible for the procedure to generate the same ID if two similar names come through within the same job run. (For example Tom Smith and Terry Smith would both generate smitt10, instead of smitt10 and smitt11.)
I've experimented with Record Count, Array Size, and Isolation level. But so far haven't been able to get the records to create unique IDs in the situation I illustrated above. I guess basically what I need is for the job to read a single record and commit it, before it brings the next record through the process. Any suggestions on how I might accomplish this?
Thanks in advance.
Tom