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 |
What is meant by a Clique?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What are the components used in smp and massively parallel processing (mpp) machines?
What is the use of teradata system software?
What is the primary index in teradata?
When tpump is used instead of multiload?
Explain the term 'foreign key' related to relational database management system?
While creating table my dba has fallback or no fallback in his ddl. What is that?
Which is more efficient group by or distinct to find duplicates?
why should we go Teradata over Oracle,what is the main differences?
What is a pseudo key? What is its use???
Difference between client character set and server character set? What is the use of these two?default character set in teradata?