I have just registered to Teradata forum and very new. If my question is posted under wrong section sincere apologies.
In one of our current project data is extracted from 1200 source tables (Residing on Oracle 10G), data is extracted using Oracle Data_Pump + PLSQL into a dump file (.dmp or .exp) and imported into Oracle Target 1200 tables using Oracle PLSQL. Just an overnight CDC from source. No transformation of Data.
We do have intentions to move our Target across to Teradata. When this happens,
Question: Can Teradata utilities read contents from Oracle (.dmp or .exp) file which is binary format in import data to target tables residing on Teradata?
Sorry, Kris, but Teradata can not read .dmp or .exp files. There is a toolkit available from Teradata that will migrate tables from Oracle to Teradata via TPT (teradata parallel transporter). It is called ora2td. Your Teradata rep can get it for you.
If the size of your Oracle Data is not too big, alternatively you can use open source ETL tool ( Kettle-Spoon ), its fast and easy, read from Oracle DB and write directly to Tearadata tables avoiding any intermediate stage.
If we will use Ora2TD for data migration, will it create tables also on teradata platform? Or it will only load the data?
If not can anyone please suggest which tools we can use for data migration which will include creation of oracle tables on teradata database, creation of corresponding indexes and partitions, data type conversions and data loading.