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 are default access rights in teradata?
What is node? How many nodes and amps used in your previous project?
How many sessions of MAX is PE capable of handling at a particular time?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What is a dimension table?
Comment whether bottleneck is an error or not.
What are the frequently used data types in teradata?
How to find duplicates in a table?
Describe the between keyword in teradata?
Explain the term 'tables' related to relational database management system?
What is the difference between fastload and multiload?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Define views in teradata with syntax.
What are the components used in smp and massively parallel processing (mpp) machines?
List out teradata data types?