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 firstname.lastname@example.org 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
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.
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.