How do you load Multiple files to a table by using fastload
scripts?
Answer / 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 |
which option is used to restart the fastexport script ?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
what is differences between Fastload and Multiload as per DBA aspect ?
What are the commands to make a new table, change a table and remove a table in teradata?
During the Display time, how is the sequence generated by Teradata?
What do you mean by fastexport in teradata?
What is the difference between fastload and multiload? Which one is faster?
Why do Hash joins usually perform better than Merge Joins?
What is a three-tier data warehouse?
What are the various indexes in teradata? How to use them? Why are they preferred?
What are the various etl tools in the market?
If the table does not have duplicates then which utility you can suggest to load the data ?