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 |
Why teradata is used?
How can we check the version of Teradata that we are using currently?
Comment whether bottleneck is an error or not.
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
How is MLOAD Teradata Server restarted after execution?
In the Primary Index, what is the score of AMPs that are actively involved?
I want to write one query How to get Matched records and unmatched records in table?
which option is used to restart the fastexport script ?
what are the day to day activities of teradata DBA ?
What is meant by a dispatcher?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
How to view every column and the columns contained in indexes in teradata?