I am new to teradata and is learning many of its features.. We want to migrate data from a teradata database to an ORacle database. For this we opted the method of exporting TD data using fast export and import/load oracle using SqlLoader. The problem with this is there are some junk characters getting exported and is loaded to Oracle. The export file we used is..
Is there any mechanism to avoid the junk characters ? what is the alternative to generate a .csv file from teradata ? Also is there any better alternative methods we can adopt for the data migration from TD to Oracle.?
What you can use is an ETL tool to perform your migration. There are open source tools available for free.
Talend Open Studio is an open source ETL tool for data integration and migration experts. It's easy to learn for a non-technical user. What distinguishes Talend, when it comes to business users, is the tMap component. It allows the user to get a graphical and functional view of integration processes. Talend also has connectors to both databases you are needing to migrate data.
I m thinking this way: .LOGTABLE fexp_logtab; .LOGON 127.0.0.1/tduser,tduser; DATABASE dbc; .BEGIN EXPORT SESSIONS 20; .EXPORT OUTFILE 'your path' FORMAT TEXT;
SELECT (CASE WHEN location_key IS NULL THEN CAST('?' AS CHAR(1)) ELSE TRIM(CAST(location_key as char(20))) (TITLE ''), CAST('-' AS CHAR(1)), (CASE WHEN CITY IS NULL THEN CAST('?' AS CHAR(1)) ELSE TRIM(CAST(CITY AS CHAR(20))) (TITLE '') FROM tduser.LOCATION;
.END EXPORT; .LOG OFF;
Subsequently, we can remove the junk charcaters. In unix it is easy.