Archives of the TeradataForum
Message Posted: Fri, 16 Jan 2009 @ 10:10:43 GMT
If you only need to pull data from Oracle and load it to Teradata database on LINUX only, then do the following:
1. Write PL/SQL to pull data from Oracle and store in any flat file.
2. Write any load script (multiload/Tpump/fastload) to load it into Teradata database.
Alternatively... If you have TPT (Teradata Parallel Transporter) in your environment then do the following:
Write a TPT script to do:
1. Get data from Oracle using "Teradata ODBC operator" as Producer and a DSN connecting Oracle
2. Load the data using "Teradata load operator"/"Teradata stream operator"/"Teradata update operator" as consumer tagetting Teradata database.
Go through the TPT documents available in www.infor.teradata.com.
Thanks & regards,
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|