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
- 12120 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 is the syntax for case when statement?
How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Does any body has TERADATA Certification Dumps, if any body is having please let me know to summee4you@gmail.o, it is very Very URGENT to me
Explain the types of join supports by teradata?
Difference between star and snowflake schemas?
What are the joins in teradata?
What is bteq utility in teradata?
How a Referential integrity is handled in Teradata?
Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update
What is the use of having index's on table?
what is the difference between bpo and call centre?
Teradata 
