How to copy 1 million records from one DB to another, Which
is effective interms of performance?
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 |
How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
Explain the types of join supports by teradata?
What are different table types used in teradata?
Can we collect statistics on multiple columns?
What are the various indexes in teradata? Why are they preferred?
What are the different softwares used with their functions in teradata?
how do you manage the production space. what are the proactive methods you can take ?
What is teradata and why it is used?
What is teradata? What are some primary characteristics of teradata?
What is the difference between fastload and multiload? Which one is faster?
What is spool space?
What is teradata?