MLOAD - UTILITY

Tools & Utilities
Fan

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

4 REPLIES
Teradata Employee

Re: MLOAD - UTILITY

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
Fan

Re: MLOAD - UTILITY

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

Fan

Re: MLOAD - UTILITY

and then move the data from teradata to sql

Teradata Employee

Re: MLOAD - UTILITY

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