Tools and Utilites

Tools

Tools and Utilites

Hi,

How to skip the last record while loading into a table by usingn BTEQ Import ,Fastload and Multiload?

Tags (1)
1 REPLY
Teradata Employee

Re: Tools and Utilites

Hi,

If you are using MultiLoad, you can take advantage of the "FOR <n>" or "THRU <n>" option in IMPORT command.

For example, if there are 3 records in your data file, adding "FOR 2" in IMPORT command can help skip the last record.

Thanks!