Transfering tables from Oracle 11 to Teradata

General

Transfering tables from Oracle 11 to Teradata

Hi! 

I'm rather new to Teradata so please sorry if the question is a simple one.

 I have 700 tables with data in Oracle 11. I need to transfer them (perform DDL and then load the data) to Teradata. Please could anyone help how can I perform it? The only method I can imagine is using an ETL tool like Informatica PowerCenter but i'm there is a more effective way. Thanks!

Tags (3)