Re: Is there any way to import MYSQL Database into Teradata at Staging Level?
I don't think you'll be able to import the Dump file, as it's most likely in a proprietary format for MySQL. OleLoad should work. It works with any data source that has some kind of OLEDB access (either native or through ODBC). It just could be time consuming, depending on how many tables you have to copy. The same thing can be done with TPT and the ODBC operator, but again it takes time. Most ETL tools (Data Integrator, DataStage, AbInitio, etc.) should also allow you to copy data from an ODBC source like a MySQL database to Teradata.