Skip to Content
0
Former Member
Jun 03, 2011 at 08:20 AM

High "Start of extraction" time

35 Views

Dear All,

A lot of times we faced with with a problem when "Start of extraction" step in DTP takes ~80% of DTP time (other 19% are writing to fact table). Sometimes the step can take 2 hours, sometimes 5 minutes. Extraction from DSO change log table with ~2 million records so it should be quite fast. Do you have any idea what can have so strong impact on this step? It is very low probability that the change log table is locked by some other process or some job writes to the DSO simultaneously. RDBMS Oracle.

Thank you.