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 the use of stored procedures in teradata?
What is a common data source for the central enterprise data warehouse?
Explain how spool space is used.
1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?
what is meant by Hot amp?
What are the different functions performed in development phase?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
What is bteq script in teradata?
How you will check the version of teradata?
Explain teradata utilities. What is multiload, fast load, tpump?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Define views in teradata with general syntax.