How to copy 1 million records from one DB to another, Which
is effective interms of performance?
Answer Posted / ugandhar
I hope you mean from one TD to other TD. Like Production
Terdata to Dev Teradata database.
In this case, write a fastexport to export the data and a
fastload/mload script to load it to other database.
Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
How can bottlenecks be identified?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is meant by a dispatcher?
What is spool space?
What is the use of fallback?
What is upsert statement in teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Explain amp in teradata?
In Teradata, what is the significance of UPSERT command?
What are the different methods ot loading a dimension table? A fact table etc?
What is teradata and why it is used?
Why managing the data is important?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
What are the frequently used data types in teradata?
What is the maximum number of dml can be coded in a multiload script?