How to copy 1 million records from one DB to another, Which
is effective interms of performance?
- 4 Answers
- 11185 Views
- I also Faced
- E-Mail Answers
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 basic teradata query language?
What are normalization, first normal form, second normal form and third normal form?
What is primary index and secondary index?
What are the string manipulation operators and functions associated with teradata?
How is MLOAD Client System restarted after execution?
What is called partitioned primary index (ppi)?
Explain and compare pros and cons of start schemas?
How do you create tables? Exact syntax, and create profiles, users in teradata?
what is sysdba and sysdbc ? which has high priority ?
What are the different methods ot loading a dimension table? A fact table etc?
Explain PDE.
Explain the advantages of partitioned primary index in a query?
Can you fastexport a field, which is primary key by putting equality on that key?
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
any one answer me how they can analyzing the project using data ware housing?
