3526327 - How to cache source tables of Joins for increased performance in Cloud Integration for data services

• How to increase the performance of a CI-DS task that contains one or more Joins?
• How to cache source tables of Joins in CI-DS?
• CI-DS task gets stuck when joining data. 
• CI-DS task containing one or more Joins takes a long time to complete running. 
• A task reading from an ABAP system and containing one or more joins fails with the following error message:
  • R3C-151001      |Data flow XXXXX|Reader XXXXX
                                                                   Error calling RFC function to get table data: <RFC_COMMUNICATION_FAILURE-
                                                                   LOCATION    SAP-Gateway on host XXXXX / XXXXX
                                                                   ERROR       Conversation XXXXX not found
                                                                   XXXXX>.

Image/data in this KBA is from SAP internal systems, sample data, or demo systems. Any resemblance to real data is purely coincidental. 

SAP Cloud Integration for Data Services

CI-DS, cloud integration, join, cache, performance, how to, stuck, slow, fast, source, reading, IBP, options, reader, increase, improve. i, icon, (i) , KBA , LOD-HCI-DS , HANA Cloud Integration for Data Services , LOD-HCI-DS-CLD , Cloud Server, UI, Task Promotion, Web Services , How To