How to copy 1 million records from one DB to another, Which
is effective interms of performance?
Answer Posted / 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 |
Post New Answer View All Answers
What is multi insert?
Explain teradata vs. Redshift?
How to view every column and the columns contained in indexes in teradata?
What is bteq utility in teradata?
What are the joins in teradata and how many types of joins are there in teradata?
What is the opening step in basic teradata query script?
In general, how do you optimze any sql in teradata?
Explain the meaning of Amp?
Explain the term 'row' related to relational database management system?
What is the use of stored procedures in teradata?
What is bteq script in teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What is primary index and secondary index?
What tools would you use for that?
What is upsert statement in teradata?