SAP Knowledge Base Article - Preview

2074582 - Lookup_ext performance problem - SAP Data Services 4.2


  • After upgrade from SAP Data Services 3.2 to 4.2 SP3 lookup_ext function where a source table of dozen million rows need to lookup values in a lookup table of dozen million rows using PRE_LOAD_CACHE has poor performance.
  • The creation of a persistent cache table is taking a very long time. It takes up to 5 times more than in previous SAP Data Services 3.2 environment.



  • SAP Data Services 4.2 SP03
  • Linux Redhat 6.5
  • Oracle 11g


SAP Data Services 4.2


PCACHE, PERFORMANCE, POOR, 4.2, SAP DATA SERVICES, DS, LOOKUP_EXT , KBA , EIM-DS , Data Services (Use Subcomponent) , Problem

About this page

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

Search for additional results

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