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 |
In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
how can i answer for question like teradat architecture in interveiw
What is Join Index in TD and How it works?
What is the use of having index on table?
What are the various reporting tools in the market?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What do you mean by tpt in teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me
Explain the advantages of partitioned primary index in a query?
What are differences between teradata and ansi session modes in teradata?
What do you mean by teradata intelliflex?