SAP components for performing inner joins between two SAP Tables

[cherishma]

I am having a scenario where I need to extract data from SAP ECC and apply some filters because there are 6 million rows in the Table. I also need to join effectively with other SAPTable which is having huge volume of data as well. Ideally If i use the TSAPinput table component and join with the other table it is consuming a lot of time.

I appreciate if anyone could suggest any ideas of making it simple and time efficient. Is there an option for me to do an inner join query in a SAP component to speed up things?

Can we use tSAPInfoCubeInput component or ELT components whihc is better?

Many thanks,

Che

[Anonymous]

Hello,

Could you please try to use tELTSAPInput/tELTSAPMap to see if it works? They support massive extraction.

Best regards

Sabrina