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
What is the maximum number of dml can be coded in a multiload script?
What are the multiload utility limitations?
What is the difference between teradata and basic rdbms?
how many modules are there in telecome domain?how to explain the architecture?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What are default access rights in teradata? What explicit right can be given to a user?
what is sysdba and sysdbc ? which has high priority ?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Explain the most common data types used in teradata?
What are the design features involved in teradata?
Define views in teradata with syntax.
What is a node in teradata? Explain
Explain teradata architecture?
Difference between multiload and tpump?