How to copy 1 million records from one DB to another, Which
is effective interms of performance?
- 4 Answers
- 10935 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 |
Steps to create a data model?
Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
can we load 10 millions of records into target table by using tpump?
What's the difference between timestamp (0) and timestamp (6)?
What is the use of having index's on table?
What do you mean by teradata intelliflex?
What is the diffrence between Multiload & Fastload interms of Performance?
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??
What does Amp contain and what are all the operations that it performs?
What are the types of tables in Teradata
22 Answers Cap Gemini, Cognizant, Infosys,
what are the day to day activities of teradata DBA ?
teradata support to automatically increase the character length or not?
Teradata 
