Symptom
When persisting view's data in SAP Datasphere, extracting data from ODP source takes longer, for example from an ADSO.
ODP Extraction jobs (ODQR_20XXXXXX_XXXXXX_000000_F) takes longer to finish.
Environment
SAP Datasphere
Cause
The extreme long running of persistence job might be caused by CDC Batch Size configuration.
Resolution
To speed up the extraction job, consider to increase the value of CDC Batch Size, for instance 50MB or 100MB in case the DPAgent has the memory capacity.
Refer to Best Practices and Sizing Guide for Smart Data Integration when used in SAP Data Warehouse Cloud for more sizing details.
In case the issue impacts only a particular view, it's recommended to set up a new dedicated Datasphere's connection with the recommended larger batch size to persist this view.
Keywords
long running, job , KBA , DS-DI-VIW , View Persistency and Runtime , How To