I am using Datastage 8.7 parallel jobs and it is required to fill a primary key attribute using DB sequence in oracle DB and for performance reasons i couldn’t use Upsert technique inside the oracle enterprise stage
But when I switched back to the oracle loader approach inside the oracle enterprise stage i couldn’t find a way for using the DB sequence
I was hoping if there is anyone could urgently help!
NOTICE: developerWorks Community will be offline May 29-30, 2015 while we upgrade to the latest version of IBM Connections. For more information, read our upgrade FAQ.
This topic has been locked.
1 reply Latest Post - 2012-12-04T20:04:15Z by beach_bum
Pinned topic Fill a primary key attribute with DB sequence using Datastge
Answered question This question has been answered.
Unanswered question This question has not been answered yet.
Updated on 2012-12-04T20:04:15Z at 2012-12-04T20:04:15Z by beach_bum
beach_bum 270001TFEN49 PostsACCEPTED ANSWER
Re: Fill a primary key attribute with DB sequence using Datastge2012-12-04T20:04:15Z in response to SystemAdminThat is an odd requirement! Maybe just a poor design element?
I think this one should go to the Oracle forums, but afaik the sql loader won't be able to populate read from seqs when writing in batch mode.