How to copy 1 million records from one DB to another, Which
is effective interms of performance?
- 4 Answers
- 11189 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / tdguy
I hope TD data mover (recently introduced) can be used to
copy db objects from one DB in a system to another system.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / rakesh
You can use NPARC process for copy data from tables in one
database to another tables in different database
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / yuvaevergreen
in case of data migration from one db to another db in two
different environments, nparcd utility or (fastexport to a
file followed by multiload) should be used. But within the
same environment, a simple insert statement would do.
| Is This Answer Correct ? | 1 Yes | 0 No |
Can you connect multiload from ab initio?
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
Can we collect statistics on multiple columns?
What is collect State in Teradata ? what it use and how it works??
What are the different functions performed in development phase?
What is meant by Teradata Gateway?
if a error occured in FASTLOAD is the fastload job stops?
What is a sparse index?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
What is the multi-insert?
Teradata 
