How do you load Multiple files to a table by using fastload
scripts?

Answer Posted / vinay

Remove End Loading statement in the script and Replace the
file one by one in the script till last file and submit
everytime so that data appended in Amp Level.
For the last file specify End Loading stmt in the script
and Run.so that it runs frm Amp to table.

Is This Answer Correct ?    10 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the string manipulation operators and functions associated with teradata?

643


If a Node is busy what are the steps you can take to avoid ?

1875


Explain fastload in teradata?

603


What are the functions of a teradata dba?

600


Explain teradata utilities. What is multiload, fast load, tpump?

578






What are the various indexes in teradata?

573


What happens when a node suffers a downfall?

671


How do you define Teradata?

612


What's the difference between timestamp (0) and timestamp (6)?

640


What tools would you use for that?

577


What do you mean by fastexport in teradata?

563


How many types of joins are there in teradata?

549


What is a clique?

587


How is MLOAD Teradata Server restarted after execution?

655


What are the design features involved in teradata?

551