|
Archives of the TeradataForumMessage 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, Sudhansu
| ||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||
Copyright 2016 - All Rights Reserved | ||||||||||||||||||||||||||||||||||||||||||||||||
Last Modified: 15 Jun 2023 | ||||||||||||||||||||||||||||||||||||||||||||||||