Teradata Cookbook

How to do it...

1. Log on to FastLoad utility. Click on the Start menu and search for FastLoad. Click on Teradata Fastload from the search results:

Screenshot of Teradata Fastload

2. Capture the flat file name which we are going to load into the Teradata Database. For this case, we will use a | separated file.

 

3. Use the following code to load the data specified in the file to the Teradata Database cookbook_fl:

.LOGON 127.0.0.1/dbc,dbc /* servername/userid,password *//* if you are using LDAP mechanism then use .logmech ldap before .logon statement for authentication*/.SESSIONS 4;.CHECKPOINT 10;  /* When to take checkpoint */.DATABASE COOKBOOK_FL ...