Skip to Content
0
Former Member
Nov 30, 2011 at 09:04 AM

First Delta after Init taking too long

38 Views

Dear experts,

We recently did a Delta init for 0HR_PT_3 which ran for about 4:15 hr and brought over half million record. We immediately followed a Delta init that ran for 4:45 hr and brought in just 600 records. The next delta after that ran in 5 mins and brought about 1800 records.

The funny part here is that during the first Delta load, there was minimum business activity and other jobs running around the same time had no such unusual load time. Even in the past, we have observed that the first delta immediately after the Delta init takes too long to load.

Has anybody faced the same problem ? What could be the root cause ?