How to copy 1 million records from one DB to another, Which
is effective interms of performance?
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 |
Difference between multiload and tpump?
which utitility can use for loading the data from non-teradata to teradata ?
what is referential constraints?how do you implement RI in teradata?
How is Teradata in current market?
What are the newly developed features of Teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What is the use of teradata system software?
How can you track login parameters of users in teradata?
Can we collect statistics on table level?
How many types of index are present in teradata?
What can be achieved by using the teradata rdbms?
Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.