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 the difference between teradata and oracle?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
How do you see a ddl for an existing table?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Differentiate primary key and partition key?
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
Can you fastexport a field, which is primary key by putting equality on that key?
Difference between stored procedure and macro?
How will you solve the problem that occurs during update?
Describe primary index in teradata?
What are the different functions performed in development phase?
How can bottlenecks be identified?
What are the components used in smp and massively parallel processing (mpp) machines?
How to select first n records in teradata?
Explain the types of join supports by teradata?