Rows coming out of CDC slows down

times29 · Post by **times29** » Mon Jan 21, 2013 12:22 pm

Hi,
I am using change capture stage
After stage i see 6825 rows/sec
Before stage has no rows as its first load

then after CDC i have transformer which do cdc=1 and 3. Performance drops
on to_transf link rows just go down to 449 rows/sec any idea who can i increase that.

Thanks

ray.wurlod · Post by **ray.wurlod** » Mon Jan 21, 2013 12:58 pm

Ignore rows/sec as indicator of performance. They include the wait time; for most stages the clock starts when the job starts. You can see this clearly using the Performance Analysis tool in Designer.