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 |
Can you fastexport a field, which is primary key by putting equality on that key?
which utitility can use for loading the data from non-teradata to teradata ?
Hash collision?
If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
What is a node in teradata?
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?
how can we analyze the locks ?
Write a single SQL to delete duplicate records from the a single table based on a column value. I need only Unique records at the end of the Query.
Mention a few of the ETL tools that come under Teradata.
What are the updated features of teradata?
How do you determine the number of sessions?
Explain parsing engine in teradata?