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 teradata?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
What are the various etl tools in the market?
What are the commands to make a new table, change a table and remove a table in teradata?
What is the difference between SI and JI?
What is bteq script in teradata?
I want to write one query How to get Matched records and unmatched records in table?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table
What are the advantages of teradata?
What do you mean by teradata intelliflex?
What is bteq utility in teradata?
What are the joins in teradata?