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 the meaning of Caching in Teradata?
What do you mean by teradata sql assistant?
Explain the new features of teradata?
Highlight the need for Performance Tuning.
how can we analyze the locks ?
What do you mean by parsing?
What do you mean by caching in teradata?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What are the functions of a teradata dba?
Steps to create a data model?
List out all forms of LOCKS that are available in Teradata.
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Describe the between keyword in teradata?
What happens when a node suffers a downfall?
What are the string manipulation operators and functions associated with teradata?