All Forums Tools
10 Mar 2015
MLOAD - UTILITY

I am new to teradata. We just creared database name SPIDER_TBLS ,  we created one test table called AATest, We have one flat file sitting in a landing pad called AATEST.txt ...it has 10 columns....  I read many example and steps but could not follow. DO you have step by step to read data from flat file into teradata. Like steps with screen shots....my email is arow2@hotmail.com  I really appreciae ..We have asked to migrate SQL to Teradata and doing smal test first.
 
Second question; From SQL server - I download ODBC drivers - How i can connect from SQL to select from the teradata table - the above load that i have asked Again thank you

Abe
feinholz 1234 posts Joined 05/08
10 Mar 2015

If you are new to Teradata, you should be using TPT, not MultiLoad.
TPT is the load/unload tool moving forward.
TPT has the ability to move data from SQL Server to Teradata without landing the data to disk.
 

--SteveF

12 Mar 2015

What i mean is to load flat file to Teradata using SQL Server ...

Abe

12 Mar 2015

and then move the data from teradata to sql
 

Abe

feinholz 1234 posts Joined 05/08
12 Mar 2015

TPT can move data from SQLServer to Teradata without landing data to disk.
The Teradata load/unload tools cannot move data in the other direction.
You will have to use another tool for that.
 

--SteveF

You must sign in to leave a comment.