Capture record count and send it to the table.

kumar444 · Post by **kumar444** » Thu Jun 23, 2011 9:50 am

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,

ray.wurlod · Post by **ray.wurlod** » Thu Jun 23, 2011 3:59 pm

Do the inserted rows include a run identifier? If so, a second job that counts those rows would do it for you.

kumar444 · Post by **kumar444** » Sun Jun 26, 2011 1:06 pm

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.