Topic
1 reply Latest Post - ‏2012-12-04T20:04:15Z by beach_bum
SystemAdmin
SystemAdmin
7754 Posts
ACCEPTED ANSWER

Pinned topic Fill a primary key attribute with DB sequence using Datastge

‏2012-12-04T15:47:47Z |
Hi Guys-

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!
Kind regards,
Maylo
Updated on 2012-12-04T20:04:15Z at 2012-12-04T20:04:15Z by beach_bum
  • beach_bum
    beach_bum
    49 Posts
    ACCEPTED ANSWER

    Re: Fill a primary key attribute with DB sequence using Datastge

    ‏2012-12-04T20:04:15Z  in response to SystemAdmin
    That 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.
    Cheers,
    A