How to copy 1 million records from one DB to another, Which
is effective interms of performance?
- 4 Answers
- 11186 Views
- I also Faced
- E-Mail Answers
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
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is collect statistics?
What is dimensional modeling?
How will you solve the problem that occurs during update?
Why managing the data is important?
What are the things to be considered while creating secondary index?
What are the various indexes in teradata? Why are they preferred?
How to Extract data from multiple legacy systems?
What is teradata?
Explain vproc in teradata?
What is node? How many nodes and amps used in your previous project?
What is the syntax for case when statement?
What are the functions performed by bynet?
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Steps to create a data model?
