How to copy 1 million records from one DB to another, Which
is effective interms of performance?
Answer Posted / 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 |
Post New Answer View All Answers
What are default access rights in teradata?
What is real time and near real time data warehousing?
What are some primary characteristics of teradata?
Name the five phases that come under MultiLoad Utility.
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What are the scenarios in which full table scans occurs?
What does sleep function does in fast load?
Explain and compare pros and cons of snow flake schemas?
If RDBMS is halted what will you do ?
What is the purpose of upsert command?
What does Amp contain and what are all the operations that it performs?
What is teradata and why it is used?
What are some commonly used bteq scripts?
How many codd's rules are satisfied by teradata database?
How do you do backup and recovery in teradata?