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
- 12269 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 does indexing improve query performance?
How many sessions of MAX is PE capable of handling at a particular time?
Highlight the advantages of PPI(Partition Primary Index).
How can bottlenecks be identified?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
What is teradata?
What are the string manipulation operators and functions associated with teradata?
What is a three-tier data warehouse?
What is a sparse index?
Which is faster fastload or multiload?
What happens when a node suffers a downfall?
What is the diffrence between Multiload & Fastload interms of Performance?
Teradata 
