Interested to Buy Any Domain ? << Click Here >> for more details...
How to copy 1 million records from one DB to another, Which
is effective interms of performance?
- 4 Answers
- 12333 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
Answer / rakesh
You can use NPARC process for copy data from tables in one
database to another tables in different database
| Is This Answer Correct ? | 2 Yes | 1 No |
Answer / 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 |
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
if a error occured in FASTLOAD is the fastload job stops?
How do you verify a complicated sql?
Describe the between keyword in teradata?
Why Multiload does not supports USI and supports NUSI?
Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M
why should we go Teradata over Oracle,what is the main differences?
What are the newly developed features of Teradata?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table
What is the difference between teradata and basic rdbms?
Teradata 
