topic SAP components for performing inner joins between two SAP Tables in Talend Studio https://community.qlik.com/t5/Talend-Studio/SAP-components-for-performing-inner-joins-between-two-SAP-Tables/m-p/2327991#M97313 <P>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.</P><P></P><P></P><P>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?</P><P>Can we use tSAPInfoCubeInput component or ELT components whihc is better?</P><P></P><P></P><P>Many thanks,</P><P>Che</P> Tue, 18 Oct 2022 08:49:45 GMT cherishma 2022-10-18T08:49:45Z SAP components for performing inner joins between two SAP Tables https://community.qlik.com/t5/Talend-Studio/SAP-components-for-performing-inner-joins-between-two-SAP-Tables/m-p/2327991#M97313 <P>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.</P><P></P><P></P><P>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?</P><P>Can we use tSAPInfoCubeInput component or ELT components whihc is better?</P><P></P><P></P><P>Many thanks,</P><P>Che</P> Tue, 18 Oct 2022 08:49:45 GMT https://community.qlik.com/t5/Talend-Studio/SAP-components-for-performing-inner-joins-between-two-SAP-Tables/m-p/2327991#M97313 cherishma 2022-10-18T08:49:45Z Re: SAP components for performing inner joins between two SAP Tables https://community.qlik.com/t5/Talend-Studio/SAP-components-for-performing-inner-joins-between-two-SAP-Tables/m-p/2327992#M97314 <P>Hello,</P><P>Could you please try to use tELTSAPInput/tELTSAPMap to see if it works? They support massive extraction.</P><P>Best regards</P><P>Sabrina</P> Mon, 31 Oct 2022 07:53:28 GMT https://community.qlik.com/t5/Talend-Studio/SAP-components-for-performing-inner-joins-between-two-SAP-Tables/m-p/2327992#M97314 Anonymous 2022-10-31T07:53:28Z