Teradata has a lot of load/unload products that load data from flat files into Teradata.
FastLoad, MultiLoad, BTEQ, Teradata Parallel Transporter just to name a few.

Hi,

Say for mload: 1)First you need to have your logtable declaration 2) Logon to database 3) You must have the target table in place or you need to create after login in 4) then you declare .begin import mload tables end mload log off;

note: there are few constraints ,please go thru mload manual

Fastload: 1)declare your sessions(min,max),errlimit 2) logon to db 3) If table is not created you can create your table(However it must be empty or no SI) 3)set record format 4) Define all the fields for the tables 5) FILE= ( all the fields as place holder)
and then logoff;

Tpump: I will send later. I am busy now.

Thanks and regards,
Raja