SAP Knowledge Base Article - Preview

3414028 - Task takes extreme long time to load hundred thousands of data to target table - SAP Cloud Integration for data services

Symptom

  • When loading hundred thousands of data, task takes extreme long time to load data to HANA target table
  • Monitor log can be below. 
    Path Name                                                 State       Row Count Elapsed time (Sec)  Absolute time (Sec) 
    =======================================================================================
    +dataflow/source                                        STOP        2709432   60.669              18310.396           
    ...
    /~dataflow/Target_Query-Mapping                STOP        196836    0.956               18310.404           
    /~dataflow/Target_Query-Distinct                 STOP        196836    0.957               18310.404           
    /~dataflow/Target_Query                             STOP        196836    18184.247           18310.404           
    -~dataflow/Target_Query_target                   STOP        196836    18241.143           18310.414  


Read more...

Environment

  • SAP Cloud Integration for data services
  • SAP HANA

Product

SAP Cloud Integration for data services 1.0

Keywords

auto correct load, performance, load, slow, long time, HANA, target, primary key, monitor , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.