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

If RDBMS is halted what will you do ?

1711


What do you mean by teradata intelliflex?

634


Different phases of multiload?

596


What are aggregate tables? How do you design them using teradata?

638


How to select first n records in teradata?

613






Describe the set operators in teradata.

583


What is primary index and secondary index?

577


Give a justifiable reason why Multi-load supports NUSI instead of USI.

682


What is oltp?

574


Can we collect statistics on multiple columns?

570


What is partitioned primary index (ppi)?

573


What is bteq utility in teradata?

575


How do you determine the number of sessions?

618


What are the available join types in teradata?

599


How do you set the session mode parameters in bteq?

614