Importing huge amount of data from Oracle DB through Workbench 5
I'm new to Domo Administration, I have configured data set connecting to Oracle DB from workbench 5, I have following questions in regards to data loading issues.
1. I have two tables in Oracle DB (Table A & both these tables have huge amount of data. Table 'A' has 500 millions rows and 20 columns and Table 'B' has 400 millions rows of data and 10 columns. I would like to know what is best practice to import the data to Domo.
2. I tried to import these two tables(A & to Domo by increasing the 'Query Execution timeout' limit in workbench but the job keeps failing may be due huge amount of data.
Please let me know what is the best practice to load the data to Domo using workbench, also need to do daily upsert for past 30 days to the dataset.
Loading these two tables to datawarehouse and connecting Domo to warehouse?
Is Domo feasable to load huge amount data?
Please let me know if you have any questions,
Thanks in advance!!