Page 1 of 1

Capture record count and send it to the table.

Posted: Thu Jun 23, 2011 9:50 am
by kumar444
I need to capture inserted ( to the Oracle EE stage as target) record count
after the job is finished and send it to the other table (oracle).
With using sequence or if possible without using sequence job.

Please help me with a suggestion.



Thanks,

Posted: Thu Jun 23, 2011 3:59 pm
by ray.wurlod
Do the inserted rows include a run identifier? If so, a second job that counts those rows would do it for you.

Posted: Sun Jun 26, 2011 1:06 pm
by kumar444
I dont have any run identifier in the job. I do use load and append option for the rows. BTW sorry for the late response.