Interested to Buy Any Domain ? << Click Here >> for more details...
How to copy 1 million records from one DB to another, Which
is effective interms of performance?
- 4 Answers
- 12349 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 |
How is MLOAD Client System restarted after execution?
can i call router is a passive transformation
Difference between multiload and tpump?
How to copy teradata scripts from ur remote desktop to server machine?
What's the difference between timestamp (0) and timestamp (6)?
What are the different functions included in the server software?
What is stored procedure in teradata?
What is meant by a dispatcher?
What is the purpose of upsert command?
how many modules are there in telecome domain?how to explain the architecture?
what is DYNAMIC SQL in TD?
What is the difference between fastload and multiload?
Teradata 
