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
- 12481 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 |
What are default access rights in teradata?
What EXPLAIN does in Teradata, what is High confidence, Low confidence and No confidence.. And How we improve the query performance .
1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?
Describe primary index in teradata. And what are the available primary index types?
Fast Load Script is failed and error tables are available then how do you restart?
Explain the meaning of Amp?
What is a dimension table?
How is Teradata in current market?
What is FILLER command in Teradata?
Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance
What is meant by a Virtual Disk?
Difference between inner join and outer join?
Teradata 
