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 explicit right can be given to a user?
Differentiate database data and data warehouse data?
Why is the case expression used in teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
How can bottlenecks be identified?
What is multi insert?
What are tpump utility limitations?
What are the uses of client software involved in teradata?
What does Amp contain and what are all the operations that it performs?
What is primary index and secondary index?
What are the newly developed features of Teradata?
Explain PDE.
What is the use of stored procedures in teradata?
What do you mean by fastexport in teradata?
What is teradata? What are some primary characteristics of teradata?