How to copy 1 million records from one DB to another, Which
is effective interms of performance?
Answer Posted / ugandhar
I hope you mean from one TD to other TD. Like Production
Terdata to Dev Teradata database.
In this case, write a fastexport to export the data and a
fastload/mload script to load it to other database.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What are the various indexes in teradata? Why are they preferred?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What are the steps involved in the process flow of the sql statement through channel attached system?
why use references rather than pointers in the public api, particularly for arguments which are modified?
Why does varchar occupy 2 extra bytes?
What is node? How many nodes and amps used in your previous project?
Explain PDE.
Explain teradata utilities. What is multiload, fast load, tpump?
How to view every column and the columns contained in indexes in teradata?
What are the different table types supported by teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
What is stored procedure in teradata?
What is smp and mpp platforms?