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 default access rights in teradata?

875


What is node? How many nodes and amps used in your previous project?

895


How many sessions of MAX is PE capable of handling at a particular time?

830


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

1926


What is a dimension table?

840


Comment whether bottleneck is an error or not.

858


What are the frequently used data types in teradata?

825


How to find duplicates in a table?

903


Describe the between keyword in teradata?

838


Explain the term 'tables' related to relational database management system?

826


What is the difference between fastload and multiload?

1045


How would you load a very large file in teradata in general? What utility would you use for it? Why?

876


Define views in teradata with syntax.

854


What are the components used in smp and massively parallel processing (mpp) machines?

845


List out teradata data types?

777