Optimize HCI-DS Joins with parallel Data Flows

[Former Member]

Hi SAP Forum

Im trying to do 3 Joins on a flow with MARA, KNVV and CKMLCR, but the task takes too much time more than 18 hours, is there a way to make this flow in paralel?

Best regards.

Luis Cabello

[Alecsandra · Accepted solution]

Hi Luis,

Seems strange to have such long processing time.

Did you try using ABAP query instead of simple query so that the transformations will not load HCI agent but happen on source side?

Best

Alecsandra

[Former Member · Accepted solution]

Im going for an ABAP Query, but im trying to bypass the process of going to the server and copying the .ABA file to ECC, is there a way to create the code directly in ECC?.

Thanks for the advice.

[Former Member]

Hi Luis,

You can try to download all those tables into flat files and join the flat files. You end up with having more Tasks however you can bypass the process of going to server and coyping .ABA file and its corresponding transports.

[former_member228602]

Hello Luis,

It is rather strange that it takes so long for processing . Do you have an estimate of the number of records the join provides. Where is the processing time spent in the execution. There are aspects to the performance

1. Time taken on abap server to return the data.

2. Any transformation on the agent (depending on your task design).

3. Post processing in Target system/Writing to destination file etc.

Additionally in your aba file can you check the SQL statements and execute them on the Abap DB via DBACOCKPIT or custom program. These information can provide insight on what is the cause of the issue and can look at optimization potential.

Thanks and Regards,

Veera