Best way to upload the oracle table data into Vertica
I have one Oracle table which data I have to used on Vertica database. so I am planning to upload that table data into Vertica database every business day.
What will be the best way to do that? do I have to use create the CSV and upload that or there is something like db link that I can use to upload the data.
thanks in Advance