Export data from BD Oracle to Vertica in less time?
Please I need you to guide me in replication environments from Oracle to Vertica.
I have a production DB in Oracle environment, this oracle DB has about 900 tables, all tables need to transfer the Vertica DB.
For this I built an ETL takes approximately 6 hours to transfer the information.
I have the following questions:
Is there any method to transfer the tables in less time?
You may only update tables that have been changed in your records?