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 is a node in teradata?
What is the difference between teradata and basic rdbms?
Explain and compare pros and cons of snow flake schemas?
Highlight the need for Performance Tuning.
What is the purpose of indexes?
How do you verify a complicated sql?
What is a three-tier data warehouse?
When tpump is used instead of multiload?
What are the components provided on node?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What are the steps involved in the process flow of the sql statement through channel attached system?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
How to find duplicates in a table?
How many sessions of MAX is PE capable of handling at a particular time?