I need suggestion on what approach to be used in terms of tools and technologies. We have TERADATA DB and VERTICA DB, we need to join few tables from both DB's and store it in VERTICA. The joins are complex and we have many data transformations to be done. Data volume is very high in TB for an hour. Pls suggest what will be the best tool to be used here.