How to copy 1 million records from one DB to another, Which
is effective interms of performance?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is a three-tier data warehouse?

702


What are the newly developed features of Teradata?

664


Explain the term 'database' related to relational database management system?

663


How do you set the session mode parameters in bteq?

689


If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

716






Explain fastload in teradata?

708


Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

656


What is the meaning of Caching in Teradata?

771


What is meant by a Channel Driver?

725


What is basic teradata query language?

716


What are the functions performed by bynet?

708


What is bteq script in teradata?

718


Highlight the points of differences between the database and user in Teradata.

682


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

680


Why do you get spool space errors? How do trouble-shoot them?

682