If I have two tables from Oracle DB and multiple tables from SAP, how can I optimize my loads in my QlikView document?
Is there an order for loads? I suppose that I need to open just one connection for both loads from Oracle DB and then loads tables from SAP. Do I need to know more?
If I can choose to open an OLEDB connection or an ODBC connection, what do I choose? The first one, right?
Thanks for your time (and sorry for my english)!